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

What is difference between sql and oracle?

0 Answers  

What is the maximum number of triggers,can apply to a single table?

2 Answers  

how many tupples can insert in 1 second in sql

1 Answers  

What port does sql server use?

0 Answers  

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

What are different types of keys?

0 Answers  

what are %TYPE and %ROWTYPE? what is the difference?

7 Answers   ICICI, Saama Tech, Sail,

what are the advantages of package?

7 Answers   iFlex,

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

What is rename in sql?

0 Answers  

Why partition by is used in sql?

0 Answers  

What is difference between db2 and sql?

0 Answers