Introduction
In this blog, we will learn how to create a table in oracle with an existing table.
You can use the "CREATE TABLE AS SELECT" (CTAS) statement to create a table structure from an existing table in Oracle SQL. This statement allows you to create a new table with the same structure as an existing one.
Here's an example,
CREATE TABLE new_table AS
SELECT *
FROM existing_table
WHERE 1 = 2;
In this example, "new_table" is the name of the new table you want to create, and "existing_table" is the name of the existing table whose structure you want to copy. The "WHERE 1 = 2" condition ensures no data is copied from the current table into the new table.
You can also specify specific columns to copy from the existing table by listing them after the "SELECT" keyword. For example,
CREATE TABLE new_table AS
SELECT column1, column2, column3
FROM existing_table
WHERE 1 = 2;
This will create a new table with only the "column1", "column2", and "column3" columns from the existing table.
Note that the new table will not have any constraints or indexes defined in the original table. You will need to add those separately if you need them.