Oracle uses the select statement to copy a table. The target table Table2 must exist. Because the target table Table2 already exists, we can also insert fields in the source table Table1.
Oracle uses the select statement to copy a table. The target table Table2 must exist. Because the target table Table2 already exists, we can also insert fields in the source table Table1.
1. insert into select statement
Statement format: Insert into Table2 (field1, field2,...) select value1, value2,... from Table1
The target table Table2 must exist. Because the target table Table2 already exists, We can insert constants in addition to the fields in the source table Table1. Example:
Insert into select statement to copy table data
2. select into from statement
Statement format: SELECT vale1, value2 into Table2 from Table1
The target table 2 does not exist because table 2 is automatically created during insertion and the specified field data in table 1 is copied to table 2. Example:
Select into from: Create a table and copy table data
,