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
How to write a query to show the details of a student from students table whose
How do you delete data from a table?
how to drop an existing view in mysql? : Sql dba
What is record variable?
What is the difference between having clause and where clause?
How to make a copy values from one column to another in sql?
How many types of indexes are there in sql?
Does oracle roll back the transaction on an error?
Does truncate free space?
What is microsoft t sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is on delete set null?
What is varchar example?
Why do we use set serveroutput on?
What are basic techniques of indexing?