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

8 votes270 views2 answers
Select current_timestamp - interval '3 days';
SQL
1 vote187 views1 answer
Select not matching data with join table
SQL
0 vote179 views1 answer
Compare if is null sql
SQL
0 vote164 views1 answer
Sqlite3 now
SQL
0 vote183 views2 answers
Mysql add days to date
SQL
104 votes289 views2 answers
Like in mysql
SQL
0 vote183 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote154 views1 answer
Alter session set nls_language french
SQL
1 vote133 views1 answer
Oracle compile schema
SQL
0 vote196 views1 answer
Display all node label neo4j
SQL