Write one update command to update seqno field of a table
on the basis of row number.
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
Which are sql * plus commands?
Does a join table need a primary key?
Why we use triggers in mysql?
What is group function in sql?
What is the use of %rowtype?
What is the difference between a query and a report?
What is optimistic concurrency control? : Transact sql
what are the advantages of sql ? : Sql dba
What is not in sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What are the types of functions in sql?
What is a natural join?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is scalar and vector?
how to run 'mysql' commands from a batch file? : Sql dba