oracle sql copy table code example

Example 1: copy table oracle

CREATE TABLE New_Table_name AS SELECT * FROM Existing_table_Name;

Example 2: oracle sql copy table without data

-- Copy datas and structure:
CREATE TABLE new_table AS SELECT * FROM my_table;
-- Copy structure only:
CREATE TABLE new_table AS SELECT * FROM my_table WHERE 1=0;