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;
PL/SQL 游标示例
最新推荐文章于 2024-06-29 17:49:39 发布