My Oracle Support Banner

Infinite Decimals and the Ceil Function (Doc ID 3045561.1)

Last updated on SEPTEMBER 04, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The Document (Doc ID 2875499.1) explains that CEIL function for infinite decimals can return an unintended value, which is a limitation of how Oracle calculates infinite decimals.


CEIL Function Unexpectedly Increments The Number (Doc ID 2875499.1)


However, the following example returns a different value than described in the document.

 

SQL> select ceil(10000/60*60) from dual;

                                CEIL(10000/60*60)
--------------------------------------------------
                                            10000  <------- According to the doc, it should be "10001".

 

 

SQL> select ceil(10000/60*30) from dual;

                                CEIL(10000/60*30)
--------------------------------------------------
                                             5001 

 

Changes

 None

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.