Technology ->
Database
2020-12-07 03:13:23
CREATE TABLE AS
1906
Introduction to Oracle Database Oracle Tables and Data definition Modifying data Oracle Query and Filter Oracle data types Joining tables Oracle Operators Grouping data Constraints
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);
Session is expired,Please login .