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
What is the purpose of the sql select top clause?
Is left join inner or outer by default?
Why are cursors used?
Does user triggers have entry for trigger with compilation errors?
Which kind of parameters cannot have a default value in pl sql?
What are the types of optimization?
Is record in pl sql?
What are schema-level triggers?
Which language is used in sql?
how many groups of data types? : Sql dba
What does the hierarchical profiler does?
What are the basic techniques of indexing?
How many clustered indexes can you have?
What is mutating table error?
What is the example of procedure?