ORACLE 参照变量(ref cursor)

DECLARE

    TYPE C1 IS REF CURSOR;

    V_CURSOR C1;

    V_NAME T_TABLE.NAME%TYPE;

    V_DESC T_TABLE.DESCRIPTION %TYPE;

BEGIN

    OPEN V_CURSOR FOR

     SELECT NAME,DESCRIPTION FROM T_TABLE;

    LOOP

     FETCH V_CURSOR INTO V_NAME,V_DESC;

     EXIT WHEN V_CURSOR%NOTFOUND;

     DBMS_OUTPUT.PUT_LINE(V_NAME ||'--------'|| V_DESC);

    END LOOP;

END;

转载于:https://www.cnblogs.com/fantinglhx/archive/2011/02/27/1966211.html