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
- 17365 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 calculate expressions with sql statements? : Sql dba
Can a trigger call a stored procedure?
what is acid property in database? : Sql dba
How does join work in sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What are pl/sql cursor exceptions?
What is sql query limit?
What's the difference between inner join and left join?
how to show all tables with 'mysql'? : Sql dba
what is sub-query? : Transact sql
Explain the difference between sql and mysql.
What are the popular database management systems in the it industry?
explain the difference between myisam static and myisam dynamic. : Sql dba
What is sharding in sql?
what are all the different types of indexes? : Sql dba
