How to copy a table in another table with datas?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the different functions in sorting an array? : Sql dba

581


Cite the differences between execution of triggers and stored procedures?

624


How does postgresql compare to mysql?

576


What is asqueryable?

533


What is pl sql in dbms?

508






What is the difference between local and global temporary table?

553


What are the sql commands?

608


How do I partition a table in sql?

542


What is assignment operator in pl sql?

566


What is the current version of sql?

540


Does truncate need commit?

518


What is the difference between clustered and non-clustered index in sql?

523


What is meaning of <> in sql?

587


What are the built in functions of sql?

565


What is AUTH_ID and AUTH_USER in pl/sql ?

1694