RE: Number problem

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Thu, 23 Dec 2004 13:52:05 +0100
Message-Id: <20041223125209.8C997A77595@ha-smtp0.tiscali.nl>

 

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 23 2004 - 06:47:41 CST