Oracle procedure with cursor

This is a basic oracle procedure with cursor:

DECLARE
CURSOR my_cursor IS
SELECT * FROM table_a LEFT JOIN table_b ON a.x = b.x
BEGIN
FOR things IN my_cursor
LOOP
-- do stuff
END LOOP
COMMIT;
END;

Leave a Reply