Re: UTL_FILE - Help

Hi Jay,

comments inline...

"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) ?

What don't you simply try it?

>
> Also if I were to concatenate fields by ||, how can I keep a fixed
> width format(including whitespaces in the fields ) in the output?

PAD the variables or use the appropriate datatype.

> 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

hth,
Guido Received on Wed Mar 17 2004 - 09:11:04 CST