Answer / 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.

Answer / 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.

Answer / kavitha nedigunta

create table new_table as select * from old_table;

EG:- create table emp1 as select * from emp;

Answer / meher

copy from user_name/password@schema_name insert
target_table_name using select * from source_table_name;

Answer / monty

if you have a table employee you can create duplicate
record using into statement

select *into backup_employee from employee

the above statement create new table backup_employee with
same data of employee

Answer / mohan

create table emp_dup as select * from emp:

if we have already structure means:

Insert into emp_dup(select * from emp);

Answer / selvaraj v

In Oracle 10g :
---------------

Create New Table in another table with same data's:
---------------------------------------------------

copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
CREATE s11 using select * from major_list;

Insert data's into another table with same data's:
---------------------------------------------------

copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
INSERT s11 using select * from major_list;

Append data's into another table with same data's:
---------------------------------------------------

copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
APPEND s11 using select * from major_list;

Replace data's into another table with same data's:
---------------------------------------------------

copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
REPLACE s11 using select * from major_list;

Answer / raghunanda

---With date from existing table to new table.
SQL> create table new_table_name as select * from old_table_name where 1=1;
---without data
SQL> create table new_table_name as select * from old_table_name where 1=2;

Thanks,

Answer / sanjeev

create table new table name as select * from new table name

Can we have two clustered index on a table?

0 Answers  

what is error ora-03113: end-of-file on communication channel?

0 Answers  

Can we alter stored procedure?

0 Answers  

how can we destroy the cookie? : Sql dba

0 Answers  

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

0 Answers  

What are different types of statements supported by sql?

0 Answers  

What are the events on which a database trigger can be based?

0 Answers  

Can one improve the performance of sql*loader? : aql loader

0 Answers  

What is Overloading of procedures ?

4 Answers   Amdocs,

Which are sql * plus commands?

0 Answers  

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

What is offset and limit in sql?

0 Answers