Oracle queries the data of one table and inserts it into another table.

Oracle queries the data of one table and inserts it into another table.

1. Add a new table through the structure and data of another table

Create table XTHAME. tab1 as select * from DSKNOW. COMBDVERSION

2. If the table exists:

Insert into tab1 select * from tab2;

 

3. In the same table, assign field A to field B:

Update table_name set B =;

 

4. Insert the field data of one table into the field data of another table

Insert into XTHAME. tab1 (pk_bdversion, vbdcode) select pk_bdversion, vbdcode from DSKNOW. COMBDVERSION;

* If a warning is reported: ORA-00928: Missing SELECT keyword Error

The reason is: tab1 (Field1, Field2,...) cannot be enclosed in single quotes.

5. Extend the 4th point. Insert multiple fields in the same table into multiple fields in multiple tables.

Insert into xthame. BUTTON (button_id, button_name, button_code) select. pk_examquest, B. pk_bdversion,. vquestname from dsknow. COMBDVERSION B, DSKNOW. RQT_EXAMQUEST a where. pk_examquest = '1001sx000000000jobv 'and B. pk_bdversion = '1000bdv1_10101001 ';

Obtain 【]Java background framework springmvc integrates the mybatis framework source code bootstrap html5 mysql oracle