Search
Your cart
  • IMG
    {{cart_item.name}}
    {{cart_item.variation_attribute_name}}: {{cart_item.variation_attribute_label}}
    {{cart_item.item_unit}}: {{ setCurrency(cart_item.price)}}
    {{ setCurrency(cart_item.price*cart_item.quantity)}}
    Invalid quantity more than stock
Total :
{{setCurrency(cart.sub_total)}}
Check out

There is no item in the cart. If you want to buy, Please click here.

CREATE TABLE AS

Oracle Database Basic Course

Created by :
Database, Oracle
course
Programming, Software and application
1756
2020-12-07 03:13:23

If you want to create a table from an existing table by copying the columns of existing table, CREATE TABLE AS statement is used.

Syntax:

CREATE TABLE new_table  
AS (SELECT * FROM old_table);


Copying selected columns of another table

Syntax:

CREATE TABLE new_table  
 AS (SELECT column_1, column2, ... column_n  
   FROM old_table);  


Copying selected columns from multiple tables

Syntax:

CREATE TABLE new_table  
AS (SELECT column_1, column2, ... column_n  
  FROM old_table_1, old_table_2, ... old_table_n);   





Oracle Trigger
Content Table
course image

Oracle Views Oracle Indexes Oracle Synonyms Oracle Sequences

Oracle Query Problem Oracle Procedure Oracle Function Oracle Cursor Oracle Trigger
Completed