Re: dbms_output.put_line

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 15 Sep 1998 06:52:21 GMT
Message-ID: <35fe0e70.2244223@news.siol.net>

On 9 Sep 1998 16:23:24 GMT, sdonor_at_daffy.wyle.com (Shirley Donor) wrote:

>
> When we issue the statement
> dbms_output.put_line(' test')
> the display truncates the leading spaces.
> How can we display the leading spaces ?
        

If you are doing this from SQL*Plus the set the following environment setting:

SQL> SET SERVEROUTPUT ON FORMAT WRAPPED
                         ^^^^^^^^^^^^^^

SQL> EXEC DBMS_OUTPUT.PUT_LINE('test'); test

SQL> EXEC DBMS_OUTPUT.PUT_LINE('     test');
     test
^^^^^

HTH,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Sep 15 1998 - 01:52:21 CDT