如何解决plsql中找不到数据的错误

j91ykkif  于 2021-07-24  发布在  Java
关注(0)|答案(1)|浏览(380)





我在这个psql编程中遇到一个错误:bind变量“end”未声明。请帮帮我。

jjjwad0x

jjjwad0x1#

绝对不需要三个循环,只需连接数据并循环一次

begin

for i in (select b.bookid,
                 b.title,
                 p.publishername as publisher,
                 a.firstname || ' ' || a.lastname as author
            from books b
      inner join publisher p on b.publisherid = p.publisherid 
      inner join author a on b.author_id = a.authorid) loop

      dbms_output.put_line(i.bookid || ' ... ' || i.title || ' ... ' || i.publisher || ' ... ' || i.author);
end loop;

end;

相关问题