Oracle-L: RE: Leading spaces in dbms_output.put

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Mon, 16 Dec 2002 13:09:05 -0800
Message-ID: <F001.0051A9E9.20021216130905@fatcity.com>

Steve,

Have a look at Metalink Doc ID: Note:108091.1

For those without Metalink access this suggests: 1) Use "format wrapped" at the end of your "Set Serveroutput" command. This works with SQL Plus version 3.3 or above. This will keep leading spaces and double spacing

2) If you're on an older database, you can use CHR(10) and CHR(9) to produce blank lines and leading spaces respectively

I have also found that
3) chr(0) works as well (found in http://www.quest-pipelines.com/Pipelines/PLSQL/archives/search.sql)

Cheers,
Bruce Reardon

-----Original Message-----
Sent: Tuesday, 17 December 2002 7:14 AM

Good afternoon,

Some time ago there was a response to the question of how to get leading spaces to display when using dbms_output.put_line.

I have tried -
dbms_output.put_line(' '||tabrec.table_name);

but do not get the leading spaces.

When someone mentioned how to do this I said "of course" but naturally have forgotten the technique.

Can some one share?

Thanks folks...
Steve Haas
Opus Consultants, LLC
860.408.1512 (office/fax)
860.651.9475 (home)
steven_haas_at_opus-consultants.com
steven.haas_at_snet.net
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Dec 16 2002 - 15:09:05 CST

RE: Leading spaces in dbms_output.put_line