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

7 votes282 views2 answers
Oracle foreign key reference table
SQL
2 votes300 views3 answers
Sql truncate table
SQL
0 vote306 views1 answer
Hour and minute between two datatime sql
SQL
0 vote295 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
1 vote288 views1 answer
Postgresql define pk sequence next number
SQL
0 vote273 views1 answer
Grepper sql workbench download
SQL
0 vote272 views1 answer
Import sql inside hide sql
SQL
0 vote263 views1 answer
Version and edition of SQL Server Database Engine
SQL
1 vote279 views1 answer
Show structure of table in sql
SQL
0 vote260 views1 answer
How to reset AI in sql
SQL