Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Thursday, 21 February 2019

Create Table With Select Statement in Oracle

We can create table by existing table or we call it is as copy of existing table by using select statement 

Create table Syntax:


CREATE TABLE < New_table_name> AS
    SELECT  Col1,Col2 …Coln  WHERE ….;
Example:
By following example we can create table along with data.
CREATE TABLE student_copy AS
           SELECT  NO,
                     NAME,
                   MARKS
            FROM student;
Example:
By following example we can create table without data.
CREATE TABLE student_copy AS
           SELECT  NO,
                     NAME,
                   MARKS
            FROM student WHERE 1=2
Share this article :

1 comments:

  1. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete