Skip to content

Oracle procedure with cursor

May 11, 2014 Development Methodology SQL

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.