Answer Posted / guest
If new table is not yet created,
create table new_table as select * from old_table;
if new table is already created,
insert into new table select * from old_table
provided the structure of the new table is same as old
table.
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
Which language is used in sql?
How do you explain an index?
What is the default isolation level in sql server? : Transact sql
define data blocks ? : Sql dba
What is the usage of nvl function?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is set serveroutput on in pl sql?
What is crud sql?
What are the different ddl commands in sql?
Which nosql database is best?
What is trigger in sql? Explain
Define union, minus, union all, intersect ?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What are triggers in sql?
How do I remove sql developer from windows 10?