Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 8141 Views
- Tech Soft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is procedure and function?
What is an implicit commit?
Do ddl statements need commit?
What is function and procedure in pl sql?
Why cross join is used?
Is progress software supports to ( pl/sql )?
what is a constraint? Tell me about its various levels. : Sql dba
What is nosql db?
explain the difference between bool, tinyint and bit. : Sql dba
What is the use of sqldataadapter?
Can you do multiple joins in sql?
Why do we use view in sql?
How do I run pl sql in sql developer?
What is pl/sql table? Why it is used?
What is a primary key sql?
