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
8307 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

explain access control lists. : Sql dba

982

What is audit logout in sql profiler?

1007

What is the execution plan in sql?

1004

What is a stored procedure in sql with example?

1108

Can you call pl/sql package functions from within a fast formula?

1024

What is sql in oracle?

1048

discuss about myisam index statistics collection. : Sql dba

939

What is mutating error?

954

What is snowflake sql?

1055

How much ram can sql express use?

967

What are tables and fields?

1019

How sql query is executed?

1115

What does trigger mean in psychology?

951

What is a database event trigger?

1138

What is auto increment feature in sql?

1111