This article is written about how to use the Oracle/PLSQL ROUND function (as it applies to numeric values) with syntax and examples.
Description
The Oracle/PLSQL ROUND function returns a quantity rounded to a sure number of decimal places.
Syntax (with numbers)
The syntax for the ROUND characteristic in Oracle/PLSQL is:
ROUND( number [, decimal_places] )Parameters or Arguments
number The quantity to round. decimal_places Optional. The wide variety of decimal places rounded to. This cost need to be an integer. If this parameter is omitted, the ROUND function will round the variety to zero decimal places.
Returns
The ROUND feature (as it applies to numbers) returns a numeric value.
Applies To
The ROUND characteristic can be used in the following versions of Oracle/PLSQL:
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
Example – with numbers
Let’s seem at some Oracle ROUND feature examples and explore how to use the ROUND characteristic in Oracle/PLSQL.
For example:
ROUND(125.315)
Result: 125
ROUND(125.315, 0)
Result: 125
ROUND(125.315, 1)
Result: 125.3
ROUND(125.315, 2)
Result: 125.32
ROUND(125.315, 3)
Result: 125.315
ROUND(-125.315, 2)
Result: -125.32