Oracle update multiple rows

To update multiple rows:

There are many steps, but the efficiency is relatively high:
1. Create Table temporary table value (select a. ID, A. Name, B. Name,... from Table1 A, Table2 B where a. ID = B. ID)
2. delete records in Table 1. Do not drop
3. insert into Table1 select the field you need from the temporary table.

 

 

Select * From tb_ai03

Create Table tb_ai031 as select * From tb_ai03

Delete from tb_ai03 A where a. yymm in ('20140901', '20160901 ')

Insert into tb_ai03
Select a. Model, A. yysal/B. unitestrip as yysal, A. mmsal/B. unitestrip as mmsal,
A. yychu/B. unitestrip as yychu, A. mmchu/B. unitestrip as mmchu, A. yymm
From tb_ld04 B, tb_ai031
Where a. Model = B. Model (+) and A. yymm in ('20140901', '20140901 ')