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 debug a stored procedure?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Can a table have no primary key?
What is join view in sql?
What is the difference between a query and a report?
What is the meaning of disabling a trigger?
Which query operators in sql is used for pattern matching?
What is parallel hint?
What is the main reason behind using an index?
What is sql injection owasp?
Can we create table in function?
Which is faster count (*) or count 1?
Do prepared statements prevent sql injection?
How do you select unique values in sql?
What is the purpose of the primary key?
