Função Oracle FLOOR

-- TRANSFORMA O TIPO NUMBER EM UM TIPO INT

SELECT FLOOR(TO_NUMBER('10.2')) AS FLOOR
  FROM DUAL;

SELECT FLOOR(-4.7) AS FLOOR
FROM DUAL;

SELECT FLOOR(TO_NUMBER('7.3')) AS FLOOR
FROM DUAL;

SELECT FLOOR(TO_NUMBER('7.9')) AS FLOOR
FROM DUAL;