What is ceil and floor in Oracle?

devquora
devquora

Posted On: Feb 22, 2018

 

    1 Answer Written

  •  devquora
    Answered by Prachi

    They both are basically opposite to each other. Here the Ceil it stands for the word Ceiling. It basically has a function to return the smallest value of an integer which is actually greater than or equal to the given number. The number here is basically rounded up to the nearest whole number.

    On the other hand in the Floor function, it generally rounds down to the nearest whole number. This returns the highest integer value which may be equal to or less than the given number.

Related Questions

Please Login or Register to leave a response.

Related Questions

NIIT Technologies Java Interview Questions

What is abstraction?

Abstraction is basically used to separate the useless data from the essential ones. Only the important things that need to be shown to the users are only being exposed. Here in these issues, the users...

NIIT Technologies Java Interview Questions

What is the difference between left and right outer join?

The difference between the left and right outer join is as follows:S. N. Left Join Outer Join1 A left outer join provides the table in the FROM clause whose all rows are returned....

NIIT Technologies Java Interview Questions

Explain how HashMap works?

HashMap in Java works on hashing principles. Hashing is a process in which hash functions are used to link key and value in HashMap....