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

Which are the most commonly used sql joins?

1 Answers  

Define the select into statement.

0 Answers  

What is the difference between sql and t sql?

0 Answers  

what is SCALAR Queries?

2 Answers   ITC Infotech,

What is the difference between SQL and PLSQL

4 Answers   IBM,

what is self join and how it works??

2 Answers   Infosys,

What has stored procedures in sql?

0 Answers  

What is a pdo connection?

0 Answers  

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

What is the basic structure of PL/SQL ?

6 Answers  

What are two statement types in sql?

0 Answers  

Can we commit in trigger?

0 Answers