create table same database.some table(some column) code example
Example: create a table from one field of another table
SQL> CREATE TABLE SALARY AS
SELECT ID, SALARY
FROM CUSTOMERS;
SQL> CREATE TABLE SALARY AS
SELECT ID, SALARY
FROM CUSTOMERS;