update table1 set seq_no =rownum where 1=1;

Write one update command to update seqno field of a table
on the basis of row number.

Question Posted / priyanka

4 Answers
17320 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / priyanka

update table1 set seq_no =rownum where 1=1;

Is This Answer Correct ?

9 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2487

What is the difference between partition and index?

975

What is the difference between explicit and implicit cursors in oracle?

1054

how to install mysql? : Sql dba

1097

What is difference between sql and mysql?

1112

Which constraints we can use while creating database in sql?

1064

how to create a table index in mysql? : Sql dba

1047

What are the built in functions of sql?

1024

How do you delete data from a table?

1016

Can we enter data in a table in design view?

964

Can a commit statement be executed as part of a trigger?

1042

What is the difference between alter trigger and drop trigger statements?

1099

Is and as keyword in pl sql?

951

Can you do multiple joins in sql?

1034

What is dialect in sql?

939