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查出来的结果显示成表格