Oracle / PLSQL: ROUND Function (with numbers)

This article is written about how to use the Oracle/PLSQL ROUND function (as it applies to numeric values) with syntax and examples.


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.


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:

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