Re: Oracle rounding question

SQL> select round(cltv + 0.01, 2) from empower.mtgterms where lnkey = '304076'

Ivica

"kboudreau" <member33017_at_dbforums.com> wrote in message news:3097653.1057874728_at_dbforums.com...
>
> rounding question....
>
> I have this:
>
> 1 select cltv
>
> 2 from empower.mtgterms
>
> 3* where lnkey = '304076'
>
> SQL> /
>
>
>
> CLTV
>
> ----------
>
> 81.1549296
>
>
> SQL> select round(cltv,2)
>
> 2 from empower.mtgterms
>
> 3 where lnkey = '304076'
>
> 4 /
>
>
>
> ROUND(CLTV,2)
>
> -------------
>
> 81.15
>
>
> I need it to round the entire number 81.1549296 to 2 decimal places
> which would bring 81.16 (6 rounds the 9 to 0 rounds the 2 to 3 rounds
> the 9 to 9 rounds the 4 to 5 rounds the 5 to 6 giving 81.16). I can't
> use round(round(cltv,3),2) as I don't know in advance how far
> out the decimal precision will be. Is there some oracle function that
> can help with this?
>
> --
> Posted via http://dbforums.com
  Received on Fri Jul 11 2003 - 16:40:55 CEST