Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL output formatting
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 KuhlerReceived on Tue Mar 23 2004 - 13:01:44 CST
![]() |
![]() |