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
- 17113 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 problem one might face while writing log information to a data-base table in pl/sql?
What are the different types of dbms?
What is an invalid partition table?
Why are aggregate functions called so?
Can we rollback delete command?
What is a database trigger?
What are primary key and foreign key and how they work?
Is record in pl sql?
what are the different type of normalization? : Sql dba
What is the difference between functions, procedures, and packages in pl/sql?
Is pl sql a scripting language?
What are % type and % rowtype?
What is oracle pl sql developer?
Which is faster count (*) or count 1?
Can delete statement be rollbacked?
