In this recipe we will see how to create a table as the result of a selection from other tables or views in the database.
The following steps demonstrate how to use use selection to create a table:
MY_SALES, and copy the
CREATE TABLE MY_SALES AS SELECT * FROM SALES WHERE ROWNUM < 1;
MY_SALESusing direct path inserting :
SET TIMING ON INSERT /*+ APPEND */ INTO MY_SALES SELECT * FROM SALES; SET TIMING OFF
DROP TABLE MY_SALES;
MY_SALESas a selection from
SET TIMING ON CREATE TABLE MY_SALES AS SELECT * FROM SALES; SET TIMING ...