Re: Trailing blanks in DBMS_OUTPUT

using UTL_FILE is another option.

Michael

• Original Message ----- From: "Paul van Dijken" <paul.vandijken_at_sema.nl> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, July 03, 2000 10:45 AM Subject: Trailing blanks in DBMS_OUTPUT

> Dear listers,
>
> For some bizarre reason, I want to print some lines using DBMS_OUTPUT with
> some lines extended to 80 characters using trailing blanks. To do this, I
> want to end these lines with a variety of spaces. Most of the lines
> howeverdo not have trailing blanks. I re-direct my default output to a
file
> (I'm using HP-UX here).
>
> When I do this, DBMS_OUTPUT removes the trailing blanks.
>
> Using SQL*Plus and spool is not allowed, since most of the lines may not
> have trailing blanks
> Using a . or a , or a ; at the end of the line is also not allowed.
>
> Does anyone know how to do this ?
>
> Thanks,
> Paul
>
> o===============================o
> | Paul van Dijken |
> | Sema Group Informatica BV |
> | Van Houten Industriepark 11 |
> | P.O. Box 143 |
> | 1380 AC Weesp |
> | The Netherlands |
> | Phone : (+31) (0) 294-239500 |
> | Fax : (+31) (0) 294-239501 |
> | e-mail:Paul.Vandijken_at_sema.nl |
> O===============================O
>
> This e-mail is confidential and intended solely for the use of the
> individual to whom it is addressed. Any views or opinions presented are
> solely those of the author and do not necessarily represent those of Sema
> Group.
> If you are not the intended recipient, be advised that you have received
> this e-mail in error and that any use, dissemination, forwarding, printing
> or copying of this e-mail is strictly prohibited.
>
> If you have received this e-mail in error, please notify Sema Group
> Informatica by telephone on (+31) 294 239 500.
>
>
> --
> Author: Paul van Dijken
> INET: paul.vandijken_at_sema.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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 Wed Aug 16 2000 - 06:16:40 CDT