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 vote330 views2 answers
Show slave status mysql
SQL
10 votes411 views6 answers
Mysql set root password
SQL
0 vote362 views1 answer
Mysql date format unix timestamp
SQL
0 vote403 views1 answer
Mysql delete entire row on condition
SQL
0 vote338 views1 answer
How to check even or odd in sql
SQL
0 vote420 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
2 votes358 views1 answer
Postgresql update sequence next value
SQL
0 vote333 views1 answer
Write sql query to show the details start from digit
SQL
0 vote334 views2 answers
How to save result of sqlite query in a table
SQL
-1 vote362 views3 answers
How to restart mysql in linux
SQL