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?
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
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What is the difference between the sql*loader and import utilities? : aql loader
What is sqlca in db2?
What are primary key and foreign key and how they work?
What are the advantages of stored procedure?
What are the advantages of pl sql?
What are string functions in sql?
What is the use of desc in sql?
What sql does db2 use?
Is delete faster than truncate?
Why stored procedure is better than query?
how would you enter characters as hex numbers? : Sql dba
What is schema in sql example?
What is an invalid partition table?
How to create an array in pl/sql?