Shulou(Shulou.com)06/01 Report--

Use stored procedures to update data in batches. Merge-update can also be used in Oracle, but it is faster to use the following stored procedures

DECLARE MAX_ROWS NUMBER DEFAULT 5000; ROW_ID_TABLE DBMS_SQL.UROWID_TABLE; DATE_TIME_TABLE DBMS_SQL.DATE_TABLE CURSOR C1 IS SELECT / * + use_hash (T1 WHERE T1.TABLE_ID T2) parallel (T1 WHERE T1.TABLE_ID 2) parallel (T2 WHERE T1.TABLE_ID 2) parallel (T2 WHERE T1.TABLE_ID 2) / T1.DATE_TIME, T2.ROWID FROM TEST_TABLE_1 T1, TEST_TABLE_2 T2 WHERE T1.TABLE_ID = T2.TABLE_ID AND T2.DATE_TIME IS NULL AND T1.DATE_TIME IS NOT NULL ORDER BY T2.ROWIDenting begin OPEN C1; LOOP EXIT WHEN C1%NOTFOUND FETCH C1 BULK COLLECT INTO DATE_TIME_TABLE, ROW_ID_TABLE LIMIT MAX_ROWS; FORALL I IN 1.. ROW_ID_TABLE.COUNT UPDATE TEST_TABLE_2 SET DATE_TIME = DATE_TIME_TABLE (I), LCD=SYSDATE WHERE ROWID = ROW_ID_TABLE (I); COMMIT; END LOOP; CLOSE C1

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.