title: Zero is missing while read data from table and writing in flat file using UTL file function in oracle
body: <p>Data in table(Oracle database)</p>
  
  <pre><code>Date        Id      Flag
  16-DEC-13   163750  1
  16-DEC-13   163755  1
  16-DEC-13   063801  1
  </code></pre>
  
  <p>whenever I'm read above data from table and writing into flat file using UTL file function,it misses zero from field in the flat file.</p>
  
  <p>Flat file
  abc.txt</p>
  
  <pre><code>16-DEC-13|163750|1
  16-DEC-13|163755|1
  16-DEC-13|63801|1
  </code></pre>