CURSORS --- URGENT , is this POSSIBLE

[balajiyes]

Hi,

This is possible if the cursor returns a single value..how to get the cursor which returns multiple values and displayit..
say SELECT EMPNO FROM EMP WHERE DEPARTMENT_NO=10;
THIS WILL RETURN FIVE ROWS..HOW TO RETREIVE IT..

balaji