SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 v_round NUMBER (10,4) := 12345.6789;
3 BEGIN
4
5 DBMS_OUTPUT.PUT_LINE('Default: '||ROUND(v_round));
6 DBMS_OUTPUT.PUT_LINE('+2: '||ROUND(v_round, 2));
7 DBMS_OUTPUT.PUT_LINE('-2: '||ROUND(v_round, -2));
8
9 END;
10 /
Default: 12346
+2: 12345.68
-2: 12300
PL/SQL procedure successfully completed.
SQL>