title: Handling zero as amount format in Oracle
body: <p>I have an amount column which needs to be in <code>225,000.00</code> format, for which below is the query that i have written</p>
  
  <pre><code>Select TRIM(to_char(pen_amt,'999,999,999,999,999.99')) as PenAmount from transact;
  </code></pre>
  
  <p>Above query is giving correct result for all values except <code>0</code>, for 0, its coming as <code>.00</code>, instead of it, it should come as <code>00.00</code>. How to do it?</p>