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
8367 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

Which is better varchar or nvarchar?

1000

How can I change database name in sql?

1087

How does an execution block start and end in pl sql?

955

What is a design view?

927

What are sql objects?

1083

what is sub-query? : Transact sql

1108

Explain the the delete statements in sql?

1069

How do you update a sql procedure?

1032

What is sql integrity?

1164

what happens if null values are involved in expressions? : Sql dba

1045

Which nosql database is best?

982

Why we use cross join?

957

How do you select unique values in sql?

1003

What is a composite primary key?

1096

What is the difference between microsoft access and sql?

1029