create table emp_dup as select * from emp: if we have already structure

How to copy a table in another table with datas?

Question Posted / mohan

Answer Posted / mohan

create table emp_dup as select * from emp:

if we have already structure means:

Insert into emp_dup(select * from emp);

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

957

what is sp_pkeys? : Transact sql

1148

Explain the methods used to protect source code of pl/sql.

1010

What is composite primary key in sql?

989

What is a dynamic query?

1016

What is a database? Explain

1103

What are the string functions in sql?

964

What is sqlcontext?

1070

How do you sort in sql?

1002

What is the difference between sql and t sql?

1024

What is a primary key sql?

1039

Is pl sql better than sql?

1016

What does bitemporal mean?

1056

Explain the savepoint statement.

1088

What has stored procedures in sql?

1055