In table three columns with 1 milion records(here there is no sequence values)

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 / rameshrevella

4 Answers
8567 Views
Tech Soft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In table three columns with 1 milion records(here there is no sequence values) i want add one more..

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

In table three columns with 1 milion records(here there is no sequence values) i want add one more..

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

In table three columns with 1 milion records(here there is no sequence values) i want add one more..

Answer / mohamed shahid

CREATE TABLE T AS SELECT ROWNUM AS seq,emp.* FROM emp;

Is This Answer Correct ?

0 Yes

2 No

In table three columns with 1 milion records(here there is no sequence values) i want add one more..

Answer / kondeti srinivas

select rownum,tablename.* frome tablename;

Is This Answer Correct ?

0 Yes

3 No

Post New Answer