But did you actualy spool the output to the OS file and open it with the text editor? Or did you simply look at the result set with some GUI tool that uses some sort of "grid" to display the result? In that case those tools usually display the whole record in a single line, marking CHR(10) with some "special" output character and continue the record on the same line.
Could you run the following in your SQL*Plus and check the result?
Code:
set heading off feedback off
spool test.txt
select 'line1' || CHR(10) || 'line2' from dual;
spool off
How many lines are there in your test.txt?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Reply With Quote