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

19 votes163 views6 answers
Mysql if null
SQL
0 vote179 views1 answer
How to input data as id in database sql c#
SQL
3 votes164 views1 answer
Insert into table from another table mysql
SQL
0 vote169 views1 answer
Two inner joins sql
SQL
-1 vote172 views2 answers
Full join sql
SQL
13 votes181 views3 answers
List all the tables in sql
SQL
1 vote150 views1 answer
Postgres set column equal to another
SQL
5 votes217 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
31 votes157 views3 answers
SQL Server change column data type
SQL
0 vote153 views1 answer
How to make case insensitive in sql
SQL