Round function (Number) Oracle

Round function for number rounded to specified integer to the right of the decimal point. It is a numeric function.


ROUND(m,[n]) – n is optional

Example :-

SQL> select round(25.6) from dual;


SQL> select round(25.4) from dual;


Some more….

round(25.48,0) returns 25
round(25.48,1) returns 25.5
round(25.22,1) returns 25.2
round(25.48,2) returns 25.48
round(25.48,-1) returns 30
round(25.48,-2) returns 0
round(25.4876,1) returns 25.5

2 responses to “Round function (Number) Oracle”

  1. There seems to be a typo for last one which says
    round(25.4876,1) returns 25 … would return 25.5

    1. Typo fixed. Appreciate for pointing out.

Leave a Reply to sqlandplsql Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: