SQL Script Continuous Collection ...

1. Copy the table

---SQL Server (including table structure and table data) SELECT * into Tabel_new from Table_old

---oracle (just replicate table structure) CREATE table table_new as SELECT * from Table_old

----Copying data
----requires that the target table Table2 must exist, and since the target table Table2 already exists, we can insert constants in addition to the fields Table1 the source table.

Insert into Table2 (field1,field2,...) Select Value1,value2,... from Table1

　　

SQL Script Continuous Collection ...