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

what are date and time intervals? : Sql dba

758


what are the different type of sql's statements ? : Sql dba

698


Is left join same as inner join?

723


Is sql pronounced sequel or sql?

951


What is indexes?

752






what is union? : Sql dba

740


What is a record in pl/sql?

763


Is it possible to create the following trigger: before or after update trigger for each row?

921


What does desc stand for?

784


Mention what pl/sql package consists of?

721


What is dbo in sql?

704


What is the difference between the sql*loader and import utilities? : aql loader

754


Why we use joins in sql?

723


Is sql a case sensitive language?

706


What is %rowtype in pl sql?

682