Create Table as Select Oracle Example

Use of Create Table AS Select Oracle Database Tutorial Example

Run Query Editor then copy & paste the below code to create a table from another table useing create table as select in Oracle Database Server Tutorial Example

   -- CONNECT AS Any User or HR

   CREATE TABLE COPY_REGIONS AS
   SELECT * FROM REGIONS;

      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

Use of Create Table AS Select Oracle Database Tutorial Example - Result in Query Editor Client Tools