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?
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
What is sql profiler in oracle?
How many joins in sql?
What is data definition language?
What is the use of function "module procedure" in pl/sql?
What is not equal in sql?
What are the different sql commands?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What are the different datatypes available in PL/SQL?
What is a full join sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What are the different ddl commands in sql?
What is %rowtype in pl sql?
Explain some predefined exceptions.
What is the difference between syntax error and runtime error?
Explain the significance of the & and && operators in pl sql.