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?
- 4 Answers
- 7464 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
What is nested table in pl sql?
What is consistency?
how is myisam table stored? : Sql dba
Which certification is best for sql?
How do you pronounce sql?
how to use myisamchk to check or repair myisam tables? : Sql dba
What are the benefits of triggers?
Explain mutating table error.
Can we perform dml on view?
How subquery works in sql?
What is a primary key sql?
What is trigger and how to use it in sql?
How do I truncate a sql log file?
What are the sql commands?
What is rollback?
