Interested to Buy Any Domain ? << Click Here >> for more details...
Write one update command to update seqno field of a table
on the basis of row number.
- 4 Answers
- 17526 Views
- HCL, I also Faced
- E-Mail Answers
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
What is percent sign in sql?
What are the three pl sql block types?
what is 'mysqld'? : Sql dba
how to write date and time literals? : Sql dba
Can procedure in package be overloaded?
Why we use joins in sql?
Name the operator which is used in the query for pattern matching?
Which is faster subquery or join?
What is meant by cursor in sql?
how to do backup entire database? : Transact sql
What are field types?
What is attribute indicator in pl sql?
What is rank dense_rank and partition in sql?
What is the difference between Union and Union all. Which is faster.
What is user in sql?
