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).
