What is ceil and floor in Oracle?

  • Sharad Jaiswal
  • 22nd Feb, 2018

1 answer(s) :

  •   Reply
    img

    Prachi

    13th Feb, 2020
    "

    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.

Post your Answer :

Valid name is required.

Valid name is required.

Valid email id is required.