title: Oracle cursor removes leading zero
body: <p>I have a cursor which selects date from column with NUMBER type containg floating point numbers. Numbers like 4,3433 are returned properly while numbers smaller then 1 have removed leading zero. </p>
  
  <p>For example number 0,4513 is returned as ,4513.</p>
  
  <p>When I execute select used in the cursor on the database, numbers are formatted properly, with leading zeros.</p>
  
  <p>This is how I loop over the recors returned by the cursor:</p>
  
  <pre><code>FOR c_data IN cursor_name(p_date) LOOP
  
  ...
  
  END LOOP;
  </code></pre>
  
  <p>Any ideas why it works that way?</p>
  
  <p>Thank you in advance.</p>