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