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 vote223 views1 answer
Char varchar nvarchar sql
SQL
1 vote239 views1 answer
Create new table in SQL from old table with data
SQL
0 vote234 views1 answer
Conda install pymysql "windows"
SQL
103 votes380 views1 answer
Like sql
SQL
22 votes261 views4 answers
Date format mysql
SQL
0 vote257 views1 answer
Change date format in oracle query
SQL
0 vote230 views1 answer
Sql find table by name
SQL
0 vote231 views1 answer
Postgresql default value boolean
SQL
5 votes289 views1 answer
Oracle ora-00054 find
SQL
0 vote270 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL