CREATE TABLE new_table_name AS SELECT column1, column2,... FROM existing_table_name code example

Example: create a table from one field of another table

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