Oracle – Create Table – Using Select Statement With Data or No Data

Here is a sample script:

WITH data
 
CREATE TABLE  test3 AS
SELECT table_name, tablespace_name
FROM all_tables;
 
---------------------------------
 
Without data
 
CREATE TABLE  ctas AS
SELECT table_name, tablespace_name
FROM all_tables
WHERE 1=2;
 
 
-- For example, create a table named EMPLOYEE3 that includes all 
-- of the column definitions from EMPLOYEE where the DEPTNO = D11.
 
CREATE TABLE EMPLOYEE3 AS
   (SELECT PROJNO, PROJNAME, DEPTNO
    FROM EMPLOYEE
    WHERE DEPTNO = 'D11') WITH NO DATA 


--