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