Use TRUNC in PL/SQL
SQL> SQL> set serveroutput on SQL> SQL> BEGIN 2 DBMS_OUTPUT.PUT_LINE(TRUNC(3.5)); 3 DBMS_OUTPUT.PUT_LINE(TRUNC(105.09,1)); 4 DBMS_OUTPUT.PUT_LINE(TRUNC(-3.5)); 5 DBMS_OUTPUT.PUT_LINE(TRUNC(105.15,-2)); 6 DBMS_OUTPUT.PUT_LINE(TRUNC(150.15,-2)); 7 END; 8 / 3 105 -3 100 100 PL/SQL procedure successfully completed. SQL>