Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL output formatting

Re: PL/SQL output formatting

From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 23 Mar 2004 19:01:44 GMT
Message-ID: <sQ%7c.9969$Lq4.5670@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
Received on Tue Mar 23 2004 - 13:01:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US