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

Written by Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of and a question and answer forum for developers. You can connect with me on Facebook and Twitter.

Leave a Reply

Your email address will not be published. Required fields are marked *