How to copy a table in another table with datas?

Answer Posted / monty

if you have a table employee you can create duplicate
record using into statement

select *into backup_employee from employee

the above statement create new table backup_employee with
same data of employee

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

discuss about myisam index statistics collection. : Sql dba

536


What does select * from mean in sql?

2022


What is minus?

559


What is trigger price?

555


What is the difference between function and procedure in pl/sql?

559






Does sql support programming?

566


Can sql function call stored procedure?

566


What is attribute indicator in pl sql?

539


What are the three forms of normalization?

545


What is a common use of group by in sql?

602


What is the purpose of cursors in pl/sql?

650


What is basic structure of pl sql?

512


How do I filter in sql profiler?

542


what is row? : Sql dba

716


Is sql database free?

541