从HELP表中获取每一行数据集,进行输出处理。 这里给出2种简单的方法 : create or replace PROCEDURE PROCEDURE3 AS TOPIC HELP.TOPIC%TYPE; -- SEQ HELP.SEQ%TYPE; -- 1. DEFINE VARIABLES %TYPE is used to INFO HELP.INFO%TYPE; -- define data type of variables the same as columns in table CURSOR FIRST_CURSOR IS --2. DEFINE CURSOR SELECT * FROM HELP; -- statements BEGIN OPEN FIRST_CURSOR; -- 3. OPEN THE CURSOR ; LOOP -- 4. FETCH RECORDS TO SET THE DATA TO VARIABLES FETCH FIRST_CURSOR INTO TOPIC,SEQ,INFO; DBMS_OUTPUT.PUT_LINE('TOPIC = '||TOPIC||',SEQ = '||SEQ||',INFO = '||INFO); EXIT WHEN FIRST_CURSOR%NOTFOUND; END LOOP; CLOSE FIRST_CURSOR; -- 5.CLOSE CURSOR ; END PROCEDURE3; create or replace PROCEDURE PROCEDURE4 AS TOPIC HELP.TOPIC%TYPE; -- SEQ HELP.SEQ%TYPE; -- 1. DEFINE VARIABLES INFO HELP.INFO%TYPE; -- CURSOR FIRST_CURSOR IS --2. DEFINE CURSOR SELECT * FROM HELP; BEGIN FOR V_RECORD IN FIRST_CURSOR LOOP DBMS_OUTPUT.PUT_LINE('TOPIC = '||V_RECORD.TOPIC||',SEQ = '||V_RECORD.SEQ||',INFO = '||V_RECORD.INFO); END LOOP; END PROCEDURE4; FOR LOOP方式无需显示对游标进行打开与关闭操作。