Do we need REF CURSOR in FOR LOOPS Options

[rivi10]

I am trying to understand the purpose of REF CURSOR.

Are strong ref cursor and weak cursor still applicable while using a FOR LOOP in a Cursor?

In the example I can use c_post.empid to display in this case.

Example:

DECLARE
CURSOR c_post IS select empid, empname from EMP;

BEGIN

FOR c_post in c_post LOOP

DBMS_OUTPUT.PUT_LINE('The value displayed is ' || c_post.empid);

END LOOP;

END;

[burleson]

Hi,

This is a DBA forum, but I have notes on ref cursors:

Please read:

http://www.dba-oracle.com/t_refcursor.htm