Oracle Create Table from Select Statement Example

Oracle Create Table from select statement command is used to create a copy of the existing table in the current schema or in another schema with or without the data.

Oracle Create Table from Select Statement Example

1. Copy a Table with the data

Create table emp_2 as select * from emp;

2. Copy a Table without the data

Create table emp_3 as select * from emp where 1 = 2;

3. Copy a Table from Another Schema

Create table emp_4 as select * from scott.emp where 1 = 2;

4. Copy a Table with Few Columns only

Create table emp_5 as select empno, ename, sal from emp;

See also:

1. Oracle 12c Create Table command
2. Export Data from Oracle Table into CSV