Press "Enter" to skip to content

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

Vinish Kapoor

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

Be First to Comment

    Leave a Reply

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