What is ceil and floor in Oracle?


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...