Re: PL/SQL Help (UTL_FILE)

Comments in-line.

Jay wrote:
> Hi All,
>
> Suppose I have cursor called EMP (multiple fields) and record is
> defined as
>
> EMP_REC EMP%ROWTYPE;
>
> Is it possible to use UTL_FILE.PUT_LINE(file1, EMP_REC) ?

No. Name the columns.

> Also if I were to concatenate fields by ||, how can I keep a fixed
> width format(including whitespaces in the fields ) in the output? I
> meant to say
> if I do fname || lname, I want the output
>
> John Saxon
> Kelly Mitchell
> Patricia Hall
>
> rather than
>
> JohnSaxon
> KellyMitchell
> PatriciaHall
>
> THANKS A LOT!
>
> J

RPAD

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)