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>