Round(23.59384 0) giving output as integer. If it is -ve it will treat the respective position value as 0.

Siva

as in u'r comment second prameter is negative so it will count 2 digit from decimal point to left side .i.e 23

this 23 is less than 50 so it will round it zero.

if u take above 50 it will round it to 100

for example;

sql> select round(88.59384 -2) from dual;

ROUND(88.59384 -2)
------------------
100