Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Trailing blanks in DBMS_OUTPUT

Trailing blanks in DBMS_OUTPUT

From: Paul van Dijken <paul.vandijken_at_sema.nl>
Date: Mon, 3 Jul 2000 15:21:46 +0200
Message-Id: <10547.111105@fatcity.com>


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. Received on Mon Jul 03 2000 - 08:21:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US