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 -> Re: Explanation of UTL_FILE.PUT_LINE please

Re: Explanation of UTL_FILE.PUT_LINE please

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 23 Oct 2006 09:54:46 -0700
Message-ID: <1161622485.408233.86980@b28g2000cwb.googlegroups.com> 





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




Apply character manipulation to every field...  for example
to_char(v_p_no,'9999')


substr(v_bay||'             ',1,9)



hth
Received on Mon Oct 23 2006 - 11:54:46 CDT












Original text of this message













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