Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do I sort a table in sql?
Which data type is a composite type?
Explain correlated query work?
What is auto increment in sql?
What is rownum?
What are the ddl commands?
What are sql constraints?
What is before and after trigger?
How is indexing done in search engines?
how to present a past time in hours, minutes and seconds? : Sql dba
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is pl sql record in oracle?
Can we use ddl statements in stored procedure sql server?
What is left join example?
explain the advantages and disadvantages of stored procedure? : Sql dba
