Re: Number problem
- From: Steve Jelfs <steve@xxxxxxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Dec 2004 13:05:45 +0000
Thanks to everyone who replied - quite a few different methods - and yes
- sorry I did mean round up to the next 5000 not nearest.
Anyhow - I think I was trying to overcomplicate so do I win the prize as
the most complex solution? ;-)
Cheers
Steve
Vinod Gopinath BMMI IS wrote:
>Or does this gives you any idea..
>
>SQL> select round(96130045, -4) from dual;
>
>ROUND(96130045,-4)
>------------------
> 96130000
>
>SQL> select round(96136462, -4) from dual;
>
>ROUND(96136462,-4)
>------------------
> 96140000
>
>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Steve Jelfs
>Sent: Thursday, December 23, 2004 3:38 PM
>To: Oracle-L Freelists
>Subject: Number problem
>
>
>Within Oracle, how can I round up an 8 figure number to the nearest 5000
>
>such that 96136462 becomes 9614000 and 96130045 becomes 96135000?
>Maths was never my strong point!!! ;-)
>
>Steve
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
