Copy table and data to new table in Oracle

How to Copy the data and script from one database table to another with or without the data?

Solution

Below query is used to create new table without data
create table xyz_new as select * from xyz;

To create table and exclude data use
create table xyz_new as select * from xyz where 1=0;

More Questions