Mistra丶 2016-10-29 13:08 采纳率: 0%
浏览 3006

oracle怎么把游标查询的结果再以表格显示出来

DECLARE
CURSOR post_cursor IS
SELECT * FROM Y_FORUM_POST;

    CURSOR postanswer_cursor(ppost_id NUMBER) IS
    SELECT * FROM Y_FORUM_POST_ANSWER
    WHERE FORUM_POST_ID=ppost_id;

BEGIN
FOR p IN post_cursor LOOP
DBMS_OUTPUT.PUT_LINE(p.FORUM_POST_ID || ' ' || p.TITLE);
FOR a IN postanswer_cursor(p.FORUM_POST_ID) LOOP
DBMS_OUTPUT.PUT_LINE(a.ANSWER_CONTENT);
END LOOP;
END LOOP;
END;
dbms输出的结果图片说明

  • 写回答

2条回答 默认 最新

  • Mistra丶 2016-10-29 13:09
    关注

    怎么把dbms显示的结果显示成这样图片说明

    评论

报告相同问题?