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

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2549

In a distributed database system, can we execute two queries simultaneously?

1147

What steps server process has to take to execute an update statement?

1014

What is varchar sql?

1201

what is 'mysqlimport'? : Sql dba

1104

Can I join the same table twice?

1090

what is the syntax used for partition in tsql? : Transact sql

1058

What is indexing oracle sql?

1138

How to Declare Fixed Length String Value In PL SQL

1201

How to execute a stored procedure?

1148

What is a rank in sql?

1003

State some properties of relational databases?

1111

what is blob? : Sql dba

1215

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1121

What are the different types of tables in sql?

1060