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 the difference between delete and truncate commands? : Sql dba

1043

how to select unique records from a table? : Sql dba

1091

What is transaction control language (tcl)?

1115

what is csv? : Sql dba

982

how to show all tables with 'mysql'? : Sql dba

1092

Why do we use set serveroutput on?

955

Is sql an operating system?

1003

What is pl sql code?

1034

How to display the records between two range in Oracle SQL Plus?

1131

What are the 3 modes of parameter?

1144

What is difference sql and mysql?

966

Name the different types of indexes in sql and define them.

1119

What are views in sql?

956

What is sql*loader and what is it used for? : aql loader

1144

what is self-join? : Sql dba

1125