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
What is the use of desc in sql?
What is union?
What is dense_rank in sql?
What are schema-level triggers?
What is the purpose of normalization?
What is a boolean in sql?
What plvcmt and plvrb does in pl/sql?
How do I find sql profiler?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is implicit cursor in pl sql?
Can we use views in stored procedure?
what is not null constraint? : Sql dba
What is the difference between sql and t sql?
Are subqueries faster than joins?
Inline the values in PL/SQL, what does it mean.?
