Re: SQL Plus - dbms output.put question
Date: Tue, 8 May 2001 21:14:40 -0700
Message-ID: <9dag71$ben$1_at_woodrow.ucdavis.edu>
Is there a way to display leading white spaces? Is there some dbms output.tab or something like that?
Or some special trick with using 'lpad( )' ?
I found this on technet.oracle.com :
SELECT LPAD('Page 1',15,'*.') "LPAD example"
FROM DUAL; LPAD example
*.*.*.*.*Page 1
Hope this helps,
-Clint
"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 Wed May 09 2001 - 06:14:40 CEST