| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Explanation of UTL_FILE.PUT_LINE please
I want to write out a flat file in which the fields are fixed sized
fields. Basically the smae length of the fields in the DB. For
instance if name is 22 chars then the field must be 22chars wide even
if the name is only 'TOM'. So my confusion is what are the pipes in
the output:
Example:
UTL_FILE.PUT_LINE(v_outputfile,v_vip||';'||v_bay||';'||v_p_no);
Currently I can see this is delimited by semi-colons. So if I wanted
the output to be fixed sized fields how would this look?
Thanks
Tom
Received on Mon Oct 23 2006 - 11:44:52 CDT
![]() |
![]() |