Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

Use TRUNC in PLSQL

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>