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

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL UTL_FILE output

Re: PL/SQL UTL_FILE output

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 19 Mar 2005 10:44:55 GMT
Message-ID: <3a2e57F67l8nbU1@individual.net>

lpad and rpad come to help.

I have a small demonstration on my webpage: http://www.adp-gmbh.ch/ora/sql/rpad.html

hth
Rene

On 2005-03-19, Randy Harris <randy_at_SpamFree.com> wrote:
>
> I'm just starting out with PL/SQL and would appreciate some advice. I've
> written a simple procedure to write some data out to a file. I would like
> the file to have fixed width fields, seperated by pipes. The data gets out
> to the file OK, but not fixed width. What can I do to correct that? Also,
> please point out my rookie mistakes.
>

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/
Received on Sat Mar 19 2005 - 04:44:55 CST

Original text of this message

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