What is the syntax of having a single statement perform the process of creating a copy of the table and have truncate operation preformed on the created table with data restore by using directload insert from the old table?

  • Interview Candidate
  • 2
  • 1100

Showing Answers 1 - 2 of 2 Answers

mala

  • Mar 7th, 2007
 

create table A as select * from B where 1=2;

this will create table using table B and there will be no data in the table(basically the structure of table is created same as table B)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions