Using create table as select
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.
How to do it...
The following steps demonstrate how to use use selection to create a table:
- Connect to the
- Create the empty table
MY_SALES, and copy the
CREATE TABLE MY_SALES AS SELECT * FROM SALES WHERE ROWNUM < 1;
- Insert all the rows from the
MY_SALESusing direct path inserting :
SET TIMING ON INSERT /*+ APPEND */ INTO MY_SALES SELECT * FROM SALES; SET TIMING OFF
- Drop the
DROP TABLE MY_SALES;
- Create table
MY_SALESas a selection from
SET TIMING ON CREATE TABLE MY_SALES AS SELECT * FROM SALES; SET TIMING ...