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

1 vote121 views1 answer
How to print longest name in sql
SQL
0 vote116 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote89 views1 answer
Mssql view column data type
SQL
2 votes109 views2 answers
Oracle multiple insert
SQL
0 vote109 views1 answer
Mysql select where text contains
SQL
22 votes116 views4 answers
Tsql rename table
SQL
0 vote121 views1 answer
How to find sql server installation folder
SQL
0 vote108 views1 answer
Import mysql'
SQL
0 vote142 views2 answers
Greater than sql server
SQL
0 vote121 views1 answer
Mysql set variable to today's date
SQL