Use TRUNC in PL/SQL : TRUNC « Numeric Math Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Numeric Math Functions
3. TRUNC

Use TRUNC in PL/SQL

 
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>

 

Related examples in the same category