PLSQL中显示游标使用的4个步骤(二)
FOR select_statement;
后面这和游标的使用相同了,如下例:
[sql]
DECLARE
TYPE refcur_type IS REF CURSOR;
book_refcur refcur_type ;
v_isbn varchar2(100);
v_title varchar2(100);
BEGIN
OPEN book_refcur FOR
SELECT ISBN, TITLE FROM BOOKS WHERE rownum<3;
FETCH book_refcur INTO v_isbn,v_title;
WHILE book_refcur%FOUND LOOP
DBMS_OUTPUT.PUT_LINE(v_isbn||': '||v_title);
FETCH book_refcur INTO v_isbn,v_title;
END LOOP; www.2cto.com
CLOSE book_refcur;
-- open cursoe with another sql statement
DBMS_OUTPUT.PUT_LINE('------- open cursoe with another sql statement');
OPEN book_refcur FOR
SELECT ISBN, category FROM BOOKS WHERE rownum<3;
FETCH book_refcur INTO v_isbn,v_title;
WHILE book_refcur%FOUND LOOP
DBMS_OUTPUT.PUT_LINE(v_isbn||': category is: '||v_title);
FETCH book_refcur INTO v_isbn,v_title;
END LOOP;
CLOSE book_refcur;
END;
作者 kkdelta