FLOOR Function in Oracle SQL – PLSQL

The FLOOR function in Oracle SQL / PLSQL is used to get a largest integer number which is less than or equal to the number passed to the function.

Syntax for the FLOOR function in Oracle SQL / PLSQL is:

SELECT FLOOR(N)
FROM table_name;

  • N is the number passed

Example 1:

SELECT FLOOR(1.23456)
FROM DUAL;

Will return “1”


Example 2:

SELECT FLOOR(2.2)
FROM DUAL;

Will return “2”


Example 3:

SELECT FLOOR(2.051)
FROM DUAL;

Will return “2”


Example 4:

SELECT FLOOR(-2.051)
FROM DUAL;

Will return “-3”


Ah! The element of surprise! T Shirt
Ah! The element of surprise! T Shirt by Squidyes
Check out Element T-Shirts online at zazzle
Tagged , , , , , , , , , , , . Bookmark the permalink.