\u6b63\u5e38\u60c5\u51b5\u4e0b\uff0cDBMS_OUTPUT\u5305\u65e0\u6cd5\u76f4\u63a5\u8f93\u51fa\u4e00\u4e2a\u7a7a\u884c\u3002
\n\u4ee5\u524d\u8fd8\u771f\u6ca1\u6709\u6ce8\u610f\u8fd9\u4e2a\u95ee\u9898\uff0c\u524d\u4e24\u5929\u60f3\u5728\u8f93\u51fa\u7ed3\u679c\u7684\u65f6\u5019\u8fdb\u884c\u4e00\u4e0b\u7b80\u5355\u7684\u683c\u5f0f\u5316\uff0c\u53d1\u73b0\u4e86\u8fd9\u4e2a\u95ee\u9898\uff1a<\/p>\n
SQL> set serverout on\r\nSQL> begin\r\n2 dbms_output.put_line('a');\r\n3 dbms_output.put_line(' ');\r\n4 dbms_output.put_line('b');\r\n5 dbms_output.new_line; \r\n6 dbms_output.put_line('c');\r\n7 end;\r\n8 \/\r\na\r\nb\r\nc\r\nPL\/SQL procedure successfully completed.<\/pre>\n\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u5728\u4e8e\uff0c\u5982\u679c\u4f7f\u7528DBMS_OUTPUT\u5305\u8f93\u51fa\u7684\u4e00\u884c\u90fd\u662f\u4e0d\u53ef\u89c1\u5b57\u7b26\uff0c\u90a3\u4e48\u8fd9\u884c\u5185\u5bb9\u88abDBMS_OUTPUT\u5305\u5ffd\u7565\u6389\u3002
\n\u867d\u7136DBMS_OUTPUT\u5305\u672c\u8eab\u5e76\u6ca1\u6709\u63d0\u4f9b\u5f00\u5173\u6765\u5c4f\u853d\u8fd9\u4e2a\u5c5e\u6027\uff0c\u4e0d\u8fc7\u8fd9\u4e2a\u95ee\u9898\u4f9d\u7136\u5f88\u5bb9\u6613\u89e3\u51b3\uff0c\u6700\u7b80\u5355\u7684\u65b9\u6cd5\u83ab\u8fc7\u4e8e\u76f4\u63a5\u628a\u56de\u8f66\u5305\u542b\u5728\u5b57\u7b26\u4e32\u4e2d\uff1a<\/p>\n
SQL> begin\r\n2 dbms_output.put_line('a\r\n3 \r\n4 b');\r\n5 dbms_output.put_line('\r\n6 c');\r\n7 end;\r\n8 \/\r\na\r\nb\r\nc\r\nPL\/SQL procedure successfully completed.<\/pre>\n\u5f53\u7136\u8fd9\u79cd\u65b9\u6cd5\u6709\u53ef\u80fd\u5bfc\u81f4PL\/SQL\u4ee3\u7801\u7684\u53ef\u8bfb\u6027\u53d8\u5dee\uff0c\u4e5f\u5bb9\u6613\u5f71\u54cd\u4ee3\u7801\u7684\u7f29\u8fdb\u683c\u5f0f\uff0c\u6b64\u5916\u8fd8\u6709\u4e00\u79cd\u65b9\u5f0f\uff1a<\/p>\n
SQL> begin\r\n2 dbms_output.put_line('a' || chr(10) || chr(13));\r\n3 dbms_output.put_line('b');\r\n4 dbms_output.put_line(chr(10) || chr(13) || 'c');\r\n5 end;\r\n6 \/\r\na\r\nb\r\nc\r\nPL\/SQL procedure successfully completed.<\/pre>\n","protected":false},"excerpt":{"rendered":"\u6b63\u5e38\u60c5\u51b5\u4e0b\uff0cDBMS_OUTPUT\u5305\u65e0\u6cd5\u76f4\u63a5\u8f93\u51fa\u4e00\u4e2a\u7a7a\u884c\u3002 \u4ee5\u524d\u8fd8\u771f\u6ca1\u6709\u6ce8\u610f\u8fd9\u4e2a\u95ee\u9898\uff0c\u524d\u4e24\u5929\u60f3\u5728\u8f93\u51fa\u7ed3\u679c\u7684\u65f6\u5019\u8fdb\u884c\u4e00\u4e0b\u7b80\u5355\u7684\u683c\u5f0f\u5316\uff0c\u53d1\u73b0\u4e86\u8fd9\u4e2a\u95ee\u9898\uff1a SQL> set serverout on SQL> begin 2 dbms_output.put_line(‘a’); 3 dbms_output.put_line(‘ ‘); 4 dbms_output.put_line(‘b’); 5 dbms_output.new_line; 6 dbms_output.put_line(‘c’); 7 end; 8 \/ a b c PL\/SQL procedure successfully completed. \u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u5728\u4e8e\uff0c\u5982\u679c\u4f7f\u7528DBMS_OUTPUT\u5305\u8f93\u51fa\u7684\u4e00\u884c\u90fd\u662f\u4e0d\u53ef\u89c1\u5b57\u7b26\uff0c\u90a3\u4e48\u8fd9\u884c\u5185\u5bb9\u88abDBMS_OUTPUT\u5305\u5ffd\u7565\u6389\u3002 \u867d\u7136DBMS_OUTPUT\u5305\u672c\u8eab\u5e76\u6ca1\u6709\u63d0\u4f9b\u5f00\u5173\u6765\u5c4f\u853d\u8fd9\u4e2a\u5c5e\u6027\uff0c\u4e0d\u8fc7\u8fd9\u4e2a\u95ee\u9898\u4f9d\u7136\u5f88\u5bb9\u6613\u89e3\u51b3\uff0c\u6700\u7b80\u5355\u7684\u65b9\u6cd5\u83ab\u8fc7\u4e8e\u76f4\u63a5\u628a\u56de\u8f66\u5305\u542b\u5728\u5b57\u7b26\u4e32\u4e2d\uff1a SQL> begin 2 dbms_output.put_line(‘a 3 4 b’); 5 … Continue reading