Thanks Bruce. That was exactly what I needed.
--- "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]> wrote: > 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) > [EMAIL PROTECTED] > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Reardon, Bruce (CALBBAY) > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > ===== Steve Haas Opus Consultants, LLC 860.408.1512 (office/fax) 860.651.9475 (home) [EMAIL PROTECTED] [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Haas INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).