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:59:36 +0300
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
