# RE: Number problem

*From*: "Vinod Gopinath BMMI IS" <vinodg@xxxxxxxxxxx>*To*: <steve@xxxxxxxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>*Date*: Thu, 23 Dec 2004 15:56:40 +0300

SQL> select round(96136462/5000)*5000 from dual; ROUND(96136462/5000)*5000 ------------------------- 96135000 SQL> select round(96130045/5000)*5000 from dual; ROUND(96130045/5000)*5000 ------------------------- 96130000 Is this OK... -----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 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l

## Other related posts:

- » Number problem
- » RE: Number problem
- » Re: Number problem
- » RE: Number problem
- » RE: Number problem
- » RE: Number problem
- » Re: Number problem
- » RE: Number problem