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

Home -> Community -> Usenet -> c.d.o.server -> Explanation of UTL_FILE.PUT_LINE please

Explanation of UTL_FILE.PUT_LINE please

From: tawright915 <tawright915_at_gmail.com>
Date: 23 Oct 2006 09:44:52 -0700
Message-ID: <1161621892.404771.276330@k70g2000cwa.googlegroups.com>


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

Original text of this message

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