CODE EXAMPLE FOR SQL

oracle create as select

CREATE TABLE my_table AS
SELECT * FROM another_table t
WHERE 1=2 --delete the where condition if you also want the data