Write one update command to update seqno field of a table
on the basis of row number.
Answers were Sorted based on User's Feedback
Answer / rk
update emp_test a set empno=7469 where (select empno from
(select rownum r,empno from emp_test) where r=6 )=a.empno
use seqno in place of empno
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / manoranan sethy
create sequence s1
start with 1
/
create table t1
(
tid number
);
insert into t1 values (s1.nextval);
insert into t1 values (s1.nextval);
insert into t1 values (s1.nextval);
insert into t1 values (s1.nextval);
insert into t1 values (s1.nextval);
select rownum, tid from t1;
update t1 set tid=6 where rownum=1;
select rownum, tid from t1;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is pragma in pl sql?
Is it possible to use LONG columns in WHERE clause or ORDER BY?
can i use global variables in stored procedure or function
What is asqueryable?
What are all the different normalization?
What is sap sql?
Can primary key be changed?
Can a commit statement be executed as part of a trigger?
What do you understand by pl/sql records?
explain what is mysql? : Sql dba
How do I debug a stored procedure?
Can we perform dml in function?