4 docs tagged with "cursors"

Learn how to use cursors with parameters in PL/SQL. Create reusable, dynamic data queries by passing values during the OPEN operation.

Master Oracle cursors. Learn how to handle multi-row result sets using Explicit cursors and understand how Implicit cursors work automatically.

Master dynamic cursor handling in PL/SQL using REF CURSOR. Learn how to pass cursors between procedures and functions for modular code.

Learn how to update or delete rows through a cursor in PL/SQL. Master the FOR UPDATE and WHERE CURRENT OF clauses for precise row manipulation.