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
- 17324 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 fetch values from testtable1 that are not in testtable2 without using not keyword?
How do I run a pl sql program?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is difference between sql and mysql?
How can I speed up sql query?
Is a secondary key the same as a foreign key?
Is pl sql still used?
what is the difference between sql and t-sql? : Transact sql
Are stored procedures faster than queries?
What is oracle sql called?
Are sql connections encrypted?
What is meaning of <> in sql?
How many joins in sql?
how to calculate the difference between two dates? : Sql dba
What is the non-clustered index in sql?
