Tag: round function syntax

• July 16, 2012

  Round function (Number) Oracle

  Round function for number rounded to specified integer to the right of the decimal point. It is a numeric function. Syntax:- ROUND(m,[n]) – n is optional Example :- SQL> select round(25.6) from dual; ROUND(25.6) ———– 26 SQL> select round(25.4) from dual; ROUND(25.4) ———– 25 Some more…. round(25.48,0) returns 25 round(25.48,1) returns 25.5 round(25.22,1) returns 25.2 […]