Write one update command to update seqno field of a table
on the basis of row number.
Answer Posted / gourvendra singh
You can update the seqno which is having the rownum=1 only.
for eg:
If you have a table dept in scott user, you can try the
following command:-
update dept
set deptno=90
where rownum=1;
the above will update the record of the table which having
the rownum=1. and if you want to update some other record
then you have to make query to make the required record as
the first record of the table.
Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
How to get unique records from a table?
Does access use sql?
What is interval partition?
What is date functions?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Is the primary key an index?
Is join and inner join the same?
What is the clause we need to add in function body to return variable?
Explain 3 basic parts of a trigger.
How do I run a program in pl sql?
Why should I use postgresql?
differentiate between float and double. : Sql dba
how are mysql timestamps seen to a user? : Sql dba
What is where clause in sql?
What is function and procedure in pl sql?