create table new_table as select * from old_table; EG:- create table emp

How to copy a table in another table with datas?

Question Posted / kavitha nedigunta

Answer Posted / kavitha nedigunta

create table new_table as select * from old_table;

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

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between the conventional and direct path loader? : aql loader

1141

What is the main difference between sql and pl/sql?

1070

How many types of triggers are there in pl sql?

1049

What is primary key in db?

991

Is mariadb a nosql database?

1035

What is group by in sql?

1072

How do I quit sql?

934

Why do we use procedures in sql?

1058

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1094

how tsql statements can be written and submitted to the database engine? : Transact sql

965

What are the advantages of sql? Explain

1082

how to load data files into tables with 'mysqlimport'? : Sql dba

1078

What company owns postgresql?

1003

What is the difference between mdf and ndf files?

1096

How does postgresql compare to oracle/db2/ms sql server/informix?

1016