Numeric Math Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Numeric Math Functions
  4. TRUNC() returns its argument truncated to the number of decimal places specified with the second argument
SQL>
Syntax:TRUNC(, )
     TRUNCATE(,))
SQL>
SQL> SELECT TRUNC(109.29, 1) truncated from dual;
 TRUNCATED
----------
     109.2