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 vote139 views1 answer
Hierarchal database table
SQL
1 vote113 views1 answer
Data type and their numeric form
SQL
1 vote118 views1 answer
Mysql remove last empty newline
SQL
2 votes148 views1 answer
Search query in mysql
SQL
0 vote131 views1 answer
Sql statement show all emails with dome
SQL
2 votes110 views1 answer
Oracle current date without time
SQL
0 vote144 views1 answer
In query in sql
SQL
0 vote274 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
8 votes118 views1 answer
Oracle add months to sysdate
SQL
13 votes125 views1 answer
Sql join 3 tables on id
SQL