SQL>SQL> select trunc( 12345.67890, 2 ) 2 from dual 3 /TRUNC(12345.67890,2)-------------------- 12345.671 row selected.SQL>SQL> --