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
8338 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 a trigger word?

1018

what is log shipping? : Sql dba

1107

What is pl sql in oracle?

1039

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1085

What is %type in sql?

962

What is union?

1158

Is a foreign key always unique?

936

What is the difference between python and sql?

995

Is sql a case sensitive language?

934

What are all ddl commands?

1080

Is nosql faster than sql?

1015

What is the difference between the implicit and explicit cursors?

1045

What does sql stand for?

986

What is a temporal table?

923

What are the advantages of pl sql?

1122