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 are dynamic queries in t-sql? : Transact sql

559

What is sqlite format?

631

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

555

Is it possible to sort a column using a column alias?

605

What is meant by user defined function?

581

What is the usage of distinct keyword?

630

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

537

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

667

Why stored procedure is better than query?

510

What is java sql drivermanager?

549

What is the size of partition table?

553

how to fetch alternate records from a table? : Sql dba

596

Why sql query is slow?

579

Can we call stored procedure in function?

552

What is PL/SQL Records?

629