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
8566 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 are pl/sql cursor exceptions?

1172

How do you select unique values in sql?

1053

Why do we use triggers?

1022

What is clause?

1231

differentiate between float and double. : Sql dba

1112

How much does sql certification cost?

1146

Show the cursor attributes of pl/sql.

1108

Can we change the table name in sql?

1006

How do I partition in sql?

1026

Explain scalar functions in sql?

1109

Which data dictionary views have the information on the triggers that are available in the database?

1302

What is memory optimized?

1137

What does dml mean?

1046

what is a composite key ? : Sql dba

1103

Is hadoop a nosql?

1054