SQLWKS> set serveroutput on
Server Output ON
SQLWKS> begin
2> dbms_output.put_line('AA'||chr(13)||chr(10)||'bb');
3> end;
4>
Statement processed.
AA
bb
SQLWKS> select 'AA'||chr(13)||chr(10)||'bb' from dual
2>
'AA'||
------
AA
bb
1 row selected.It Seems no problem in SQLworksheet , I guess if the output is displayed in a format of grid , the newline will not be displayed properly
Server Output ON
SQLWKS> begin
2> dbms_output.put_line('AA'||chr(13)||chr(10)||'bb');
3> end;
4>
Statement processed.
AA
bb
SQLWKS> select 'AA'||chr(13)||chr(10)||'bb' from dual
2>
'AA'||
------
AA
bb
1 row selected.It Seems no problem in SQLworksheet , I guess if the output is displayed in a format of grid , the newline will not be displayed properly
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货