Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
-- 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;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.