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
17120 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 composite primary key in sql?

939

what is meant by urlencode and urldocode? : Sql dba

1090

What is mdb stand for?

960

what are ddl statements in mysql? : Sql dba

1112

What is package in pl sql with an examples?

971

How many types of normalization are there?

895

What are the indexing methods?

1002

What is the maximum number of rows in sql table?

956

what are the 'mysql' command line options? : Sql dba

1016

how many tables will create when we create table, what are they? : Sql dba

1019

How to add, remove, modify users using sql?

978

What are the types of sql commands?

1018

What is denormalization in a database?

994

How delete all data from all tables in sql?

884

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2527