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 vote169 views1 answer
Drop a view in sqlite
SQL
0 vote125 views1 answer
Change schema of all tables postgres
SQL
1 vote118 views1 answer
Mysql best tutorial for beginners
SQL
0 vote129 views1 answer
Power bi union columns
SQL
0 vote118 views1 answer
Check sql database table lock
SQL
2 votes130 views1 answer
Add default sql server
SQL
0 vote143 views1 answer
Check if mysql db is used
SQL
0 vote134 views1 answer
Import excel to sql
SQL
1 vote151 views1 answer
Insert column after column mysql
SQL
0 vote124 views1 answer
Run sql script file and changes db name in this file using c#
SQL