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

13 votes309 views5 answers
Oracle list tables
SQL
0 vote323 views1 answer
Mysql command line ubuntu
SQL
1 vote343 views1 answer
Postgres killing connections on db
SQL
0 vote329 views1 answer
Number(10 2) in sql means
SQL
3 votes346 views1 answer
Oracle sleep
SQL
28 votes385 views6 answers
Sql update
SQL
1 vote346 views1 answer
Apex ORA-20999
SQL
1 vote336 views5 answers
Sql 2nd highest salary
SQL
0 vote342 views1 answer
Alasql delete column
SQL
0 vote346 views1 answer
Ansi sql count duplicate rows
SQL