Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL output formatting
"Richard Kuhler" <noone_at_nowhere.com> wrote in message
news:sQ%7c.9969$Lq4.5670_at_twister.socal.rr.com...
| Mark C. Stock wrote:
| <snip>
| > you're experiencing sql*plus being over-zealous in stripping leading
blanks
| > you will not see the same behavior in all other tools, for instance toad
| > in sql*plus, i believe you'll need to use a leading non-space to prevent
| > this behavior -- unless there's a setting that i've not yet run across
;-)
|
| This is causes by the word wrapping process in SQL*Plus. Switch to
| standard wrapping and it will work fine ...
|
| set serveroutput on size 1000000 format wrapped
|
| --
| Richard Kuhler
|
|
|
exec dbms_output.put_line(' well, i''ll be.... !')
i guess it pays to reread the manual on stuff that you thought you knew!
thanks, richard
(with a little remedial sql*plus reading, i was reminded of EMBEDDED, which
i've not used in ages, and i also see that SET SQLBLANKLINES ON will save a
bit of aggravation in some situations)
;-{ mcs Received on Tue Mar 23 2004 - 16:40:47 CST