creating a table from an existing table code example

Example 1: create a table from one field of another table

SQL> CREATE TABLE SALARY AS
   SELECT ID, SALARY
   FROM CUSTOMERS;

Example 2: sql create table with columns as another table

SELECT * INTO newtable FROM oldtable WHERE 1 = 0;