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
- 17298 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
How to select all records from the table?
Can we use commit inside a trigger?
Why do we use partitions in sql?
Is it important to partition hard disk?
What are the types of variables use in pl sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
What are inner outer left and right joins in sql?
How to create an array in pl/sql?
Explain 3 basic parts of a trigger.
What is normalization in sql?
What are all the common sql functions?
Does normalization improve performance?
What is bind reference and how can it be created?
What are stored procedures used for?
What is difference between primary and secondary key?
