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
- 8364 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 are the types of optimization?
What is a recursive stored procedure?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Is left join same as join?
Why are aggregate functions called so?
Why commit is not used in triggers?
What is self-join and what is the requirement of self-join?
Do ddl statements need commit?
Is natural join same as inner join?
Why do we use view in sql?
How can use stored procedures in sql?
What is sql catalog?
Can variables be used in sql statements?
what is msql? : Sql dba
