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

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 / mohamed shahid

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

Answer Posted / mohamed shahid

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

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is table? : Sql dba

1062

what are the limitations of identity column? : Transact sql

1108

How to run sql commands in sql*plus?

1180

Is id a reserved word in sql?

1145

Show code of a cursor for loop.

1054

Why do we use %rowtype & %type in plsql?

1048

what is commit? : Sql dba

1071

What is trigger in sql?

1097

How do I edit a trigger in sql developer?

993

What is primary key and unique key?

1119

What is a Mapplet?

1120

Explain the the delete statements in sql?

1062

Where is sql database stored?

979

In what condition is it good to disable a trigger?

1010

Can we create clustered index without primary key?

962