Oracle Stored Procedure for statement usage

Oracle Stored Procedure for statement usage, which is submitted once every 500 rows. CreateorreplaceprocedurePS_TESTISbeginFORiIN1 .. nested loop -- deletefromtestwherenameto_char (I );

Oracle Stored Procedure for statement usage, which is submitted once every 500 rows. Create or replace procedure PS_TEST IS begin FOR I IN 1 .. 10000 LOOP -- delete from test where name = to_char (I);-insert into test VALUES (to_char (I), I + 2); if mod (I, 500) = 0 then commit; end if;

Oracle Stored Procedure for statement usage, which is submitted once every 500 rows.

Create or replace procedure PS_TEST IS
Begin
FOR I IN 10000
LOOP
-- Delete from test where name = to_char (I );
-


Insert into test VALUES (to_char (I), I + 2 );
If mod (I, 500) = 0 THEN
COMMIT;
End if;
End loop;
COMMIT;
End PS_TEST;