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: