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;
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;
You must be <a href="https://jonathansblog.co.uk/wp-login.php?redirect_to=https%3A%2F%2Fjonathansblog.co.uk%2Foracle-procedure-with-cursor">logged in</a> to post a comment.