Oracle Create Table from Select Statement Example

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

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