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