Live ORACLE

DECLARE

TYPE cursor_ref IS REF CURSOR;

c1            CURSOR_REF;

TYPE emp_tab IS TABLE OF employees%ROWTYPE;

rec_tab       EMP_TAB;

rows_fetched  NUMBER;

BEGIN

OPEN c1 FOR 'SELECT * FROM employees';



FETCH c1 BULK COLLECT INTO rec_tab;



rows_fetched := c1%ROWCOUNT;



dbms_output.Put_line('Number of employees fetched: '

                    ||To_char(rows_fetched));

END;

/

Number of employees fetched: 107

PL/SQL procedure successfully completed.

Accessing %ROWCOUNT For an Explicit Cursor