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>
|