create sequence s1 start with 1 / create table t1 ( tid number );

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

Question Posted / manoranan sethy

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between my sql and sql?

1056

What is the most restrictive isolation level? : Transact sql

1075

How do you modify a column in sql?

984

what is the difference between where clause and having clause? : Sql dba

992

can a stored procedure call itself or recursive stored procedure? : Sql dba

1018

What is mutating error in pl sql?

1011

What is the use of sqlerrd 3?

936

What are the different types of tables in sql?

994

Can you have a foreign key without a primary key?

947

What is the use of primary key?

1003

what tools available for managing mysql server? : Sql dba

1070

What is the purpose of a sql?

971

How can I change database name in sql?

1065

Can we create index on primary key?

957

what is a trigger? : Sql dba

1020