RE: Number problem

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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 Received on Thu Dec 23 2004 - 06:48:40 CST