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

Which data type is a composite type?

979

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1003

Are sql database names case sensitive?

993

how can we destroy the cookie? : Sql dba

1004

What are the types of queries in sql?

1072

What are secondary keys?

964

how to fetch common records from two tables? : Sql dba

1168

Which is faster subquery or join?

1199

What is flag in sql?

1026

What is the difference between local and global temporary table?

1031

How to use transactions efficiently : transact sql

1042

What does the file extension accdb stand for?

963

How do you declare a variable in pl sql?

1017

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2157

Is a table valued function object?

1002