How to copy a table in another table with datas?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to include numeric values in sql statements? : Sql dba

768


What is relationship? How many types of relationship are there?

787


What is dialect in sql?

700


What is synchronized subquery?

820


How do I run pl sql in sql developer?

855






What is db journal file?

677


Explain cursor types?

750


What is normalization in sql?

717


Which is better stored procedure or query?

721


What are expressions?

754


how are mysql timestamps seen to a user? : Sql dba

772


how to use 'mysql' to run sql statements? : Sql dba

737


Which one is faster ienumerable or iqueryable?

655


How do you determine the current isolation level? : Transact sql

750


What is a sql profiler?

770