Write one update command to update seqno field of a table
on the basis of row number.
- 4 Answers
- 15639 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 many sql commands are there?
What is the difference between view and stored procedure?
Why stored procedure is faster than query?
Why use triggers in sql?
Can you join views in sql?
how to create a new view in mysql? : Sql dba
Could you please provide oca (oracle 10g) dumps for my certification ?
what are the different type of normalization? : Sql dba
How many types of literals are available in pl sql?
Explain the insert into statements in sql?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
how tsql statements can be written and submitted to the database engine? : Transact sql
Who is the owner of mysql database?
Write an sql query to select all records from the table?
Explain what is table in a database?
