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

Answer Posted / priyanka

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the three forms of normalization?

1045

What are %type and %rowtype for?

1052

what are the advantages and disadvantages of views in a database? : Sql dba

1043

Can we insert data in view?

967

What is a clob in sql?

1022

Why indexing is needed?

987

Explain what is an index?

1057

What are the different datatypes available in PL/SQL?

1085

how can you create an empty table from an existing table? : Sql dba

1154

How does postgresql compare to "nosql"?

1031

what are the 'mysql' command line options? : Sql dba

1072

Which is better trigger or stored procedure?

950

Why is a trigger used?

943

How can you get sql*loader to commit only at the end of the load file? : aql loader

1014

what is the difference between char_length and length? : Sql dba

1045