DEVFYI - Developer Resource - FYI

What command is used to create a table by copying the structure of another table?

PL/SQL Interview Questions and Answers

(Continued from previous question...)

What command is used to create a table by copying the structure of another table?

CREATE TABLE .. AS SELECT command
Explanation:
To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the following.
CREATE TABLE NEWTABLE AS SELECT * FROM EXISTINGTABLE WHERE 1=2;
If the WHERE condition is true, then all the rows or rows satisfying the condition will be copied to the new table.

(Continued on next question...)

Other Interview Questions