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 ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is sql*plus?
Name the operator which is used in the query for pattern matching?
What is the best sql course?
Why do we need a foreign key?
define join and explain different type of joins? : Sql dba
Cite the differences between execution of triggers and stored procedures?
How do you update f as m and m as f from the below table testtable?
What are the different types of constraints?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is a behavioral trigger?
Does truncate remove indexes?
What is sqlservr exe?
What is cross join sql?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How do I start sql from command line?