有沒有為了dbms_output.put_line會"吃掉"最前面的空格而苦惱?
scott@O9I.US.ORACLE.COM> set serveroutput on
scott@O9I.US.ORACLE.COM> exec dbms_output.put_line(' abc');
abc
PL/SQL procedure successfully completed.
(俺以前曾經(jīng)很苦惱為了保留空格, 嘗試了加".", 加不可見字符等辦法, 不過終究覺得不自然)
實際上, 只要在set serveroutput on后加上format wrapped參數(shù), 就可以避免這個問題
scott@O9I.US.ORACLE.COM> set serveroutput on format wrapped
scott@O9I.US.ORACLE.COM> exec dbms_output.put_line(' abc');
abc
PL/SQL procedure successfully completed.