I just noticed that running this in a test window:
results in:
which has a space character where there should just be a blank line. Is this space character added by PL/SQL Developer or by Oracle?
The same happens in a command window with "SET SERVEROUTPUT ON". I tried to reproduce it in SQL*Plus but SQL*Plus did its own weird thing and completely discarded the new_line.
(Oracle 11gR1, PL/SQL Developer 9.0.6.1665)
Code:
begin
dbms_output.put_line('hello');
dbms_output.new_line;
dbms_output.put_line('world');
end;
results in:
Code:
hello
[space]
world
which has a space character where there should just be a blank line. Is this space character added by PL/SQL Developer or by Oracle?
The same happens in a command window with "SET SERVEROUTPUT ON". I tried to reproduce it in SQL*Plus but SQL*Plus did its own weird thing and completely discarded the new_line.
(Oracle 11gR1, PL/SQL Developer 9.0.6.1665)