Re: SQL Plus - dbms_output.put question

Just put ascii char 255 instead of 32 as a space ... Should work.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tfg8o9aa8148fa_at_beta-news.demon.nl...
> This is a 'feature' both for sqlplus 3.3, 8.0 and 8.1
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <psaf_at_dontspamme.memo.ikea.com> wrote in message
> news:9d93ms$cdi$1_at_mailgate.ikea.com...
> > Hello,
> > I would like to know if I can get SQL Plus to display the leading blank
> > spaces
> > in the examples bellow.
> > I want to extract formated DDL scripts but SQL Plus keeps throwing them
 away
> > Or is it just a default behavior and I can´t do anything about it.
> >
> > I am using SQL PLUS version 3.3.4.0.0
> >
> > Any hints?
> >
> > Thanks
> > Pavel
>
> --------------------------------------------------------------------------
> --
> > ---------------------------------------
> > comp_at_Compass CH >
> > comp_at_Compass CH >
> > 1 begin
> > 2 dbms_output.put_line (' ksjksjdhksjh');
> > 3 end;
> > 4 /
> > ksjksjdhksjh
> >
> > PL/SQL procedure successfully completed.
> >
> > comp_at_Compass CH > ED
> > Wrote file afiedt.buf
> >
> > 1 begin
> > 2 dbms_output.put(' lksjdf');
> > 3 dbms_output.put_line ('h');
> > 4* end;
> > comp_at_Compass CH > /
> > lksjdfh
> >
> > PL/SQL procedure successfully completed.
> >
> >
> >
>
>
Received on Sun May 13 2001 - 20:23:03 CEST