ROUND

ROUND#

Functionality: #

This Oracle function will return number rounded to the indicated number of decimal places.

Parameters:#

NUMBER The original number
PLACES (optional) The number of decimal places (default is 0)

Returns: #

Number

Errors:#

None

Example:#

round(~) will return 3 if the value passed is from 3.00 to 3.499999 and 4 if the value is 3.50000 to 3.999999 round(~,2) will round the number passed to 2 decimal places


Notes #

Click to create a new notes page