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 if we write return in procedure?

1331

what are the difference between clustered and a non-clustered index? : Sql dba

976

What are pl/sql cursors?

986

What is nvarchar max in sql?

959

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1083

What is set serveroutput on?

1086

How can I change database name in sql?

1000

What is error ora-12154: tns:could not resolve the connect identifier specified?

1015

Does truncate table reset auto increment?

938

Explain constraints in sql?

979

What is a schema? How is it useful in sql servers?

1041

What is the use of count (*) in sql?

977

What is clause?

1062

What is sp_helptext?

1004

how to enter characters as hex numbers? : Sql dba

992