RE: Number problem
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <steve@xxxxxxxxxxxxxx>, "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Dec 2004 13:52:05 +0100
SQL> select 5000*ceil(96136462/5000) from dual;
5000*CEIL(96136462/5000)
------------------------
96140000
SQL> select 5000*ceil(96130045/5000) from dual;
5000*CEIL(96130045/5000)
------------------------
96135000
Lex.
----------------------------------------------------------------
Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html
----------------------------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Steve Jelfs
Sent: Thursday, December 23, 2004 13:38
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:
