title: Padding Zeroes in Decimals Oracle Database
body: <p>I am having some issues dealing with numeric columns and data stored in tables. The columns are of type Number(14,2). If there are any decimal digits in numbers (like 1234.65) then it works fine. But when the numbers like 1234.00 are stored the decimal zeroes are removed when stored in tables. Another case is when numbers like 1234.50 are stored it stores as 1234.5</p>
  
  <p>This is causing issue when I am retrieving the values, it is not consistent when it is displayed on User screens. We are handling the decimal digits based on flag whether to display or not. When chosen to display the number wont align because of this mismatch stored in database. The UI would display like this.</p>
  
  <pre><code>      0
  
        0
  
  14922.9
  
  14922.9
  
  14922.93
  </code></pre>
  
  <p>But I want it to look like this if I wanted to show values after decimal point - </p>
  
  <pre><code>    0.00
  
      0.00
  
  14922.90
  
  14922.90
  
  14922.93
  </code></pre>
  
  <p>This can be fixed on UI side, but the problem is every application using this table has to fix on its own UI part. We have a SQL view which is reading this table.</p>
  
  <p>So I was wondering if there a way to fix this from SQL side and can be handled in SQL view query.</p>
  
  <p>Any help is appreciated.</p>