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 is the difference between blob and text? : Sql dba

1060

What is sql and how does it work?

1247

What are different types of functions in sql?

1050

What is a memo field?

1015

What is the order of sql select?

1085

Is inner join faster than left join?

1248

What is indexing oracle sql?

1142

What are the types of functions in sql?

1062

Is postgresql a nosql database?

1221

what is the difference between inner and outer join? Explain with example. : Sql dba

1061

Is t sql a programming language?

1109

Does oracle use sql?

986

What is sql analyzer?

1059

what does the t-sql command ident_incr does? : Transact sql

1121

How can you load multi line records? : aql loader

1121