MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
-- Run a loop to update 100,000 rows DECLARE i NUMBER(10) := 1; startd DATE := SYSDATE; BEGIN WHILE i <= 100000 LOOP update work_order_items t2 set t2.action_on_close = ( select t1.action_on_close from work_orders t1 where t1.id = t2.wo_id ); i := i + 1; -- Commit after each 10,000 row IF MOD(i, 10000) = 0 THEN COMMIT; END IF; END LOOP; -- Output the execution time in seconds DBMS_OUTPUT.PUT_LINE((SYSDATE - startd)*24*60*60); END;
|Query to identify changes between rows of two tables||8||55|
|form builder not starting||3||55|
|Oracle Insert not working||10||30|
|Is their a way to log which lines were executed in an Oracle stored procedure?||2||23|