Hi That's a simple one . (if table is tab1) 1. Add column first

In table three columns with 1 milion records(here there is
no sequence values) i want add one more column with
sequence values from the first how it is posible?

Question Posted / shekharjchandra

4 Answers
8330 Views
Tech Soft, I also Faced
E-Mail Answers

Answer Posted / shekharjchandra

Hi
That's a simple one . (if table is tab1)

1. Add column first
ALTER TABLE tab1 add col1 number ;

2. Update the col1 of tab1
UPDATE tab1 SET col1=ROWNUM.

This will populate all the rows in sequential numbers.

Hope this solves u r problem
regards
JC

Is This Answer Correct ?

16 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you update a value in sql?

1034

What is an emotional trigger?

1001

Why we use join in sql?

957

What is varray in pl sql?

1067

what is cross join? : Sql dba

992

What is a pragma statement?

1262

What is the use of function in sql?

1085

What is row_number () in sql?

978

How do you modify a table in sql?

1116

What is a variable in sql?

996

What is a parameter query?

1071

What is embedded sql in db2?

1007

how do you know the version of your mysql server? : Sql dba

1000

Why we use pl sql?

955

In a distributed database system, can we execute two queries simultaneously?

1078