Declaring a SYS_REFCURSOR cursor variable v17

The following is the syntax for declaring a SYS_REFCURSOR cursor variable:

<name> SYS_REFCURSOR;

Where name is an identifier assigned to the cursor variable.

This example shows a SYS_REFCURSOR variable declaration:

DECLARE
    emp_refcur      SYS_REFCURSOR;
        ...