Rounding numbers to 2 digits after comma in oracle
<p>I'm looking for any way to be able to round or trunc the numbers to 2 digits after comma. I tried with <code>round</code>, <code>trunc</code> and <code>to_char</code>. But didn't get what I wanted.</p>

<pre><code>select round(123.5000,2) from dual;
select round(123.5000,2) from dual;
</code></pre>

<p>Works fine, but when I have zero as second digit after comma,  I get only one 1 digit  after comma in output number</p>

<pre><code>select  to_char(23.5000, '99.99') from dual;
</code></pre>

<p>Works fine, but if the number before comma has 3 digits, I'm getting '###' as output.
Apart from that I'm getting here spaces at the beginning. Is there any clear way to remove these spaces?</p>

<p>I'm looking a way to always get a number with two digits after comma and for all numbers(1,10,100 etc). </p>