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 -> Space in the output

Space in the output

From: Erika Grondzakova <Erika.Grondzakova_at_cern.ch>
Date: Tue, 26 Oct 1999 16:53:24 +0200
Message-ID: <3815C064.8E76E19C@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 - 09:53:24 CDT

Original text of this message

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