FLOOR and CEIL bug ??
From: Domenico Gambelli <domenico_at_webbridges.it>
Date: 1998/12/05
Message-ID: <36692910.EBA77054_at_webbridges.it>#1/1
Date: 1998/12/05
Message-ID: <36692910.EBA77054_at_webbridges.it>#1/1
I have made this query:
select (90523434-31289)/(90492145/19)
[Quoted] Division,floor((90523434-31289)/(90492145/19))
Floor,ceil((90523434-31289)/(90492145/19)) Ceil from dual;
and the resul is :
Division Floor Ceil
---------- ---------- ----------
19 18 19
For me there is a Oracle bug. What do you thing ??
--
Gambelli Domenico
E-Mail: domenico_at_webbridges.it
Tel.:+39 06 47823776 Fax :+39 06 48906270 GSM :+39 0347 7513467Received on Sat Dec 05 1998 - 00:00:00 CET