Oracle FLOOR function.

Preamble

The Oracle/PLSQL FLOOR function returns the largest integer value equal to or less than a number.

Oracle/PLSQL syntax of the FLOOR function

FLOOR( number_id )

Parameters and function arguments

• number_id value – is used to determine the largest integer value equal to or less than number.

The FLOOR function returns an integer value.

The FLOOR function can be used in the following versions of Oracle/PLSQL

Let’s consider some examples of the FLOOR function and learn how to use the FLOOR function in Oracle/PLSQL.

SELECT FLOOR(5.9) FROM DUAL;

--Result: 5

SELECT FLOOR(34.29) FROM DUAL;

--Result: 34

SELECT FLOOR(-5.9) FROM DUAL;

--Result: -6

The Oracle FLOOR function will return the largest integer value less than the specified number

About Enteros

​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​