Question: how to copy data from one table to another new table in oracle?
Answer: Answer: To do this, the Oracle CREATE TABLE syntax is: CREATE TABLE new_table AS (SELECT * FROM old_table WHERE 1=2);