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

4 votes252 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote317 views1 answer
Wordpress make wp user in db
SQL
2 votes281 views2 answers
Sql percentage
SQL
6 votes299 views3 answers
Create database mysql utf8
SQL
0 vote300 views1 answer
Make parameters nullable in sql server
SQL
10 votes297 views2 answers
What is database
SQL
0 vote280 views2 answers
What is the default password for sql server sa
SQL
5 votes258 views1 answer
Oracle get nls settings
SQL
3 votes281 views1 answer
How to find names includes in sql
SQL
1 vote277 views3 answers
Drop unique key constraint in sql server
SQL