select trunc(3.455,2) as trunc from dual;
trunc -------- 3.45
select trunc(3.455,0) from dual; trunc ------ 3
select trunc(13.455,-1) from dual; trunc ------ 10