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

explain the delete statements in sql

1028

What are the advantages of sql? Explain

1083

Can delete statement be rollbacked?

968

What does closing a cursor do?

1303

What is t sql used for?

1005

How can you select unique records from a table?

1053

How to connect a sql*plus session to an oracle server?

1113

Can you have more than one trigger on a table?

985

what are date and time data types in mysql? : Sql dba

953

Explain dml and ddl?

963

What will you get by the cursor attribute sql%notfound?

1040

How do you sort in sql?

990

What is trigger and stored procedure in sql?

1017

What is normalization in a database?

1143

Differentiate between % rowtype and type record.

1278