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;

Similar codes

0 vote312 views1 answer
Mysql update sequence with order by
SQL
27 votes338 views6 answers
Sql update record
SQL
3 votes340 views1 answer
Kill mysql processlist in whose time more than 200
SQL
3 votes313 views3 answers
Mysqldump: couldn
SQL
11 votes311 views1 answer
How to get ddl for materialized view
SQL
6 votes331 views2 answers
Mysql get yesterday
SQL
6 votes352 views4 answers
Mysql update set
SQL
0 vote324 views1 answer
Mysql update table from select on another table
SQL
7 votes337 views3 answers
Select latest entry in sql table
SQL
0 vote341 views1 answer
Sql order by except one row
SQL