title: Convert 987,654,321.09 format string into 987,654,321.09 number format in oracle
body: <p>I trying to convert a string 987,654,321.09 into a number with the same format
  I am using a case in my select statement as follows:</p>
  
  <pre><code>select 
  case when NUMBER_FORMAT is null or NUMBER_FORMAT = 0 
  then
  to_number ('987,654,321.09', '999,999,999.99')
  else
  NUMBER_FORMAT end as numberFormat
  from agileuser;
  </code></pre>
  
  <p>This query returns the format as 987654321.09.</p>
  
  <p>Does anybody knows how can this can be returned as 987,654,321.09 in number datatype.</p>