Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

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> --