Write one update command to update seqno field of a table on the basis of row

Write one update command to update seqno field of a table
on the basis of row number.

Question Posted / shailendra t

4 Answers
17290 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Write one update command to update seqno field of a table on the basis of row number...

Answer / priyanka

update table1 set seq_no =rownum where 1=1;

Is This Answer Correct ?

9 Yes

0 No

Write one update command to update seqno field of a table on the basis of row number...

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

Write one update command to update seqno field of a table on the basis of row number...

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

Write one update command to update seqno field of a table on the basis of row number...

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

Post New Answer