Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

Use ROUND function in PLSQL

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