有几个问题：
放在一起，并稍微调整格式和结构，使它更像“惯用的” PL / sql：
DECLARE
CURSOR bookcursor IS
SELECT btname, isbn, pubname, datedestroyed
FROM booktitle bt
JOIN publisher p
ON bt.pid = p.id -- this is just a guess
JOIN bookcopy bc
ON bt.bcid = bc.id -- this is just a guess
WHERE datedestroyed IS NULL
;
bookcursorrec bookcursor%rOWTYPE;
BEGIN
OPEN bookcursor;
LOOP
FETCH bookcursor INTO bookcursorrec;
EXIT WHEN bookcursor%NOTFOUND;
dbms_output.put_line( 'ISBN: ' ||bookcursorrec.isbn
|| ' - Book Name: ' || bookcursorrec.btname
|| ' - Publisher: ' || bookcursorrec.pubname );
END LOOP;
CLOSE bookcursor;
END;
/
顺便说一句，甲骨文标识符大多是区分大小写（因为他们是隐式转换为大写，除非你在双引号包起来），所以通常人们会用类似的标识符book_cursor_rec和date_destroyed，而不是bookCursorRec（=bookcursorrec）和dateDestroyed（= datedestroyed）。
602392714
清零编程群