SQL statement used to copy a table from Oracle

1. copy only the SQL statements of the Table Structure

Create Table tablename2 as select * From tablename1 where 1 <> 1

2. SQL statement used to copy the table structure and data in the table

Create Table tablename2 as select * From tablename1

 

3. SQL statement used to create fields for Oracle replication tables

Create Table tablename2 as select row_id, name, age from tablename1 where 1 <> 1 // The premise is that row_id, name, age are all columns of Table.
 
4. Copy the specified fields of the table and the SQL statement of the data of these specified fields
Create Table tablename2 as select row_id, name, age from tablename1
Although the preceding statements can easily create tablename2 tables based on tablename1 table structure replication, the indexes of tablename1 tables cannot be copied and must be manually created in tablename2.
 
5. Insert into saves the query result to an existing table.
Insert into tablename2 (column1, column2,...) (select column1, column2,... from tablename1)
 
.....