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
- 6937 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
explain commit and rollback in mysql : sql dba
What is the current version of sql?
Why sql query is slow?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
How to use distinct and count in sql query? Explain
What is a sql select statement?
what is the difference between group by and order by in sql? : Sql dba
what is row? : Sql dba
How can one get sql*loader to commit only at the end of the load file? : aql loader
What are two statement types in sql?
Is keyword pl sql?
What is the difference between the conventional and direct path loader? : aql loader
How is indexing done in search engines?
What is the cause of mutating table error and how can we solve it?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
