Answer Posted / kavitha nedigunta
create table new_table as select * from old_table;
EG:- create table emp1 as select * from emp;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is java sql drivermanager?
How to place comments in pl/sql?
What is a common use of group by in sql?
Differentiate between syntax and runtime errors.
What is the use of desc in sql?
What is crud diagram?
Can two tables have same primary key?
What is sqlerrd?
What is delimiter in pl sql?
What are the two different parts of the pl/sql packages?
How many primary keys can a table have?
What do you understand by exception handling in pl/sql?
What is duration in sql profiler trace?
Can procedure in package be overloaded?
What is rank function in sql?