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 vote178 views1 answer
Change data type in mysql
SQL
1 vote205 views5 answers
What is in operator in sql
SQL
1 vote176 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote199 views1 answer
Create domain sql
SQL
0 vote196 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
5 votes179 views1 answer
JBDC
SQL
0 vote180 views1 answer
Wp_query raw sql
SQL
3 votes175 views1 answer
Select without null values sql
SQL
2 votes178 views1 answer
Install sqlite npm
SQL
4 votes211 views1 answer
Describe table mysql
SQL