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

Home -> Community -> Usenet -> c.d.o.server -> Re: Space in the output

Re: Space in the output

From: Erika Grondzakova <Erika.Grondzakova_at_cern.ch>
Date: Tue, 26 Oct 1999 17:47:23 +0200
Message-ID: <3815CD0B.5451F03@cern.ch>


Hello Neil,

Thanks a lot, it helps.
BTW don't you know wheter is possible to change default TAB setting? Now the TAB settings is every eight characters and I would need less..:-(

Thanks again,

Erika

Neil C wrote:
>
> Not sure the exact answer, but a tab instead of spaces worked for me ??
>
> HTH
>
> NeilC
>
> Erika Grondzakova wrote in message <3815C064.8E76E19C_at_cern.ch>...
> >Hello,
> >
> >Is it possible to force somehow Oracle in SQL*Plus to get output of the
> >DBMS_OUTPUT.PUT_LINE command with the leading spaces?
> >
> >Following example will print the word hello from the beginning from the
> >line:
> >
> >SQL> begin
> > 2 dbms_output.put_line(' hello');
> > 3 end;
> > 4 /
> >hello
> >
> >And I would like to display it with the leading spaces :
> > hello
> >
> >Actually I need it in the file where I'm spooling the output.
> >
> >Thank you in advance,
> >
> >Erika
Received on Tue Oct 26 1999 - 10:47:23 CDT

Original text of this message

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