PL/SQL 游标示例

FUNCTION booktitle（isbn_in IN varchar2)

RETURN varchar2

IS

l_title books.title%TYPE;

           CURSOR icur  IS SELECT title FROM books where isbn=isbn_in;

BEGIN

         OPEN  icur ;

         FETCH icur  INTO ltitle;

         CLOSE icur ;

        RETURN l_title;

END;