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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / saraswathi muthuraman
SQL> desc ts_200;
Name Null? Type
----------------------------------------- --------
A NUMBER
SQL> alter table ts_200 add b number;
Table altered.
SQL> desc ts_200;
Name Null? Type
----------------------------------------- --------
A NUMBER
B NUMBER
SQL> select * from ts_200;
A B
---------- ----------
1
3
7
3 rows selected.
SQL> update ts_200 set b=rownum;
3 rows updated.
SQL> select * from ts_200;
A B
---------- ----------
1 1
3 2
7 3
3 rows selected.
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / mohamed shahid
CREATE TABLE T AS SELECT ROWNUM AS seq,emp.* FROM emp;
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / kondeti srinivas
select rownum,tablename.* frome tablename;
Is This Answer Correct ? | 0 Yes | 3 No |
What are the advantages of indexing?
How to start oracle sql developer?
What is the difference between rollback and rollback to statements?
Is pl sql a scripting language?
What is query optimization in sql?
What is meaning of <> in sql?
Define sql delete statement.
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar
Can a table contain multiple foreign key’s?
What is scalar and vector?
how to retrieve the top 2 salaried persons from a database?