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

5 votes166 views1 answer
Mysql where one year ago
SQL
1 vote156 views1 answer
How to select multiple columns from different tables in mysql
SQL
1 vote206 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
3 votes142 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote179 views1 answer
Sql anywhere create procedure
SQL
0 vote153 views1 answer
Sql put two columns into one
SQL
5 votes159 views1 answer
Oracle drop index if exists
SQL
0 vote145 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
3 votes136 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
2 votes153 views5 answers
SQL trigger
SQL