<div>
Try round(), such as at:<br />
<a href="http://www.techonthenet.com/oracle/functions/round_nbr.php" rel="ugc">http://www.techonthenet.com/oracle/functions/round_nbr.php</a>
</div>


Try round(), such as at:
http://www.techonthenet.com/oracle/functions/round_nbr.php [http://www.techonthenet.com/oracle/functions/round_nbr.php]

<div>
oracle round function does not work for this case
</div>


oracle round function does not work for this case

<div>
select ceil(number*100)/100
</div>


<div>
A second look then, suggests you want a zero placeholder to supress trailing zeros, but a non-zero value always rounds up to the next increment. &nbsp;Correct?<br />
<br />
If so then no, nothing I'm immediately able to put my finger on -- but am I on the right track now?
</div>


A second look then, suggests you want a zero placeholder to supress trailing zeros, but a non-zero value always rounds up to the next increment.  Correct?

If so then no, nothing I'm immediately able to put my finger on -- but am I on the right track now?

<div>
<div class="content wysiwyg-content">
is there a oracle function to convert <br />
<br />
a) 2.0718 &nbsp;=&gt; &nbsp;2.08 &nbsp;and<br />
b) 2.0700 &nbsp;=&gt; &nbsp;2.07 &nbsp;<br />
<br />
thanks
</div>
</div>


is there a oracle function to convert 

a) 2.0718  =>  2.08  and
b) 2.0700  =>  2.07  

thanks

ORACLE ROUNDING

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.