Oracle produce synchronization intermediate Database

The oracle produce synchronization intermediate database is used as an Internet system on an existing system. Considering the server pressure or the absence of conditions, it can directly connect to the database of an existing system. You need to get an intermediate database to synchronize business data at a specific time. Note the Writing Method of SQL code INSERT INTO sy_api_c_meter (task_id, meter_id ,.....) SELECT in_task_id, meter_id ,.... FROM c_meter a, c_mp B, c_meter_mp_rela c WHERE. meter_id = c. meter_id AND B. mp_id = c. mp_id AND B. cons_id = v_cons_id AND B .org _ no = v_org_no the select query statement in the preceding SQL statement has no performance problems. The partition conditions AND indexes can all be taken up, but the insert statement will become very difficult when executed together. This is an error that occurs at the beginning of the write process. The cursor should be used. The Modification result is as follows: SQL code FOR cur IN (SELECT c. meter_id FROM c_mp B, c_meter_mp_rela c WHERE B. mp_id = c. mp_id AND B. cons_id = v_cons_id AND B .org _ no = v_org_no) LOOP INSERT INTO sy_api_c_meter (task_id, meter_id, inst_loc ,....) SELECT in_task_id, meter_id ,.... FROM c_meter a WHERE. meter_id = cur. meter_id; end loop; in actual operations, batch operations on table data are much faster.