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 vote233 views1 answer
Sql tabelle erstellen
SQL
0 vote274 views1 answer
ALV GRID events
SQL
0 vote236 views1 answer
How to locate pg_hba.conf file
SQL
0 vote229 views1 answer
Mysql limit order by
SQL
5 votes200 views1 answer
Mysql select greater than yesterday
SQL
0 vote167 views1 answer
Update sql join multiple tables
SQL
25 votes217 views6 answers
Sql update query
SQL
0 vote216 views1 answer
Drop all procedures sql server
SQL
7 votes213 views2 answers
Get database size mysql
SQL
5 votes232 views1 answer
Get table columns from sql
SQL