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
What is linq to sql?
What are the differences between in and exists clause?
How to assign sql query results to pl sql variables?
What is left join example?
What is normalization in a database?
How to place comments in pl/sql?
Why commit is not used in triggers?
Is delete faster than truncate?
Can we call dml statement in function?
What are views in sql?
Does pl sql work in mysql?
Does access use sql?
Is merge a dml statement?
What is the difference between numeric and autonumber?
What is faster join or subquery?