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 vote331 views2 answers
Default constraint in ms sql
SQL
0 vote288 views1 answer
Hallo
SQL
0 vote310 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
4 votes304 views1 answer
Oracle delete last row
SQL
0 vote325 views1 answer
Less mysql display
SQL
0 vote334 views1 answer
Get last three characters in mysql column
SQL
7 votes323 views5 answers
Show details of table postgres
SQL
1 vote319 views1 answer
Mysql backup skip table
SQL
2 votes356 views2 answers
Create table mysql integer NOT null
SQL
1 vote304 views1 answer
Sql delete all values in a column
SQL