Oracle store procedure & cursor

CREATE OR REPLACE PROCEDURE TESTING

AS

F_DATE VARCHAR2(10);

CURSOR Hello_Cursor IS

Select A from <your table> where A='ABC';

BEGIN

    OPEN Hello_Cursor;

    FETCH Hello_Cursor INTO F_DATE;

    DBMS_OUTPUT.PUT_LINE(F_DATE);

    CLOSE Hello_Cursor;

END;

解釋：將SQL每一條取出的記錄都放進Hello_Cursor，每一次執行Cursor的時候都將值放進F_DATE