**

PL/SQL Cursors: Understanding Normal and Ref Cursors

PL/SQL cursors are used to process query results, but there are two types: normal cursors and ref cursors. A normal cursor is a static cursor with a fixed query defined at compile-time, while a ref cursor is a pointer to a result set that allows dynamic query execution.

Normal cursors are suitable for processing known, static result sets within a single PL/SQL block. Ref cursors, on the other hand, provide greater flexibility and can be used to return result sets from procedures and functions or pass data between PL/SQL blocks and external programs.

**

Source: https://dev.to/mrcaption49/normal-cursor-and-ref-cursor-8bp