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 ? | 21 Yes | 1 No |
Post New Answer View All Answers
Write the command to remove all players named sachin from the players table.
how to see the create table statement of an existing table? : Sql dba
What are the types of index in sql?
What is cross join sql?
Is sql procedural language?
What is the main reason behind using an index?
Does sql support programming?
How do you take the union of two tables in sql?
What is varchar data type in sql?
How do you explain an index number?
What is the purpose of the partition table?
What is a native sql query?
Which table is left in left join?
What is a sql*loader control file?
How to assign sql query results to pl sql variables?
