oracle-copy table structure and table data

1. Copy table structure and table data

CREATE TABLE Table_new as SELECT * from Table_old

2. Duplicate table structure

CREATE TABLE Table_new as SELECT * from Table_old where 1<>1

3. Copying the specified fields of a table

CREATE TABLE Table_new as select O.column1,o.column2 from Table_old o where 1<>1

4. Copying data from a specified field in a table

CREATE TABLE Table_new as select O.column1,o.column2 from Table_old

Simple description, as a beginner, write down to stay after the technical review of the ~

oracle-copy table structure and table data