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 is the purpose of a secondary key?
What is blind sql injection?
How do I partition in sql?
What is foreign key sql?
What is Primary Key?
Can a varchar be a primary key?
How do you truncate?
When is the explicit cursor used ?
What is difference between db2 and sql?
Does user triggers have entry for trigger with compilation errors?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
what is datawarehouse? : Sql dba