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

6 votes164 views2 answers
Mysql 1 day ago
SQL
0 vote145 views1 answer
SAP Return
SQL
0 vote149 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote206 views1 answer
Insert query return id mysql
SQL
0 vote219 views1 answer
Placements hackerrank solution
SQL
0 vote173 views4 answers
Convert databse to achieve log mode oracle
SQL
4 votes136 views1 answer
Sql group by year
SQL
5 votes156 views6 answers
In operator sql
SQL
0 vote151 views1 answer
Excel export from sql using python
SQL
-2 votes155 views1 answer
Remove root password mysql
SQL