title: Converting integer value from a db column to text in oracle
body: <p>I have a requirement in db.</p>
  
  <p>1).Table ABC, column: <code>check_amount number number(18,4)</code>. This basically contains check amount for eg. 3000.50 to be paid to an employee.</p>
  
  <p>Now a cheque is issued and that check contains this check_amount in number as well as in text form.for eg.check will have:</p>
  
  <p><code>pay to &lt;emplyee_name&gt; ****$3000.50****   ****THREE THOUSAND DOLLARS AND FIFTY CENTS****</code></p>
  
  <p>I have to generate this text using DB column value and display that on check.</p>
  
  <p>Can anybody help me out, how can i achieve this in oracle 11g ?</p>
  
  <p>Hint:I have heard of Julien format, but that is not working. Any suggestions is greatly appreciated.</p>
  
  <p>From 
  Nalin</p>