Oracle ROUND function (FOR NUMBER).

Preamble

The Oracle/PLSQL ROUND function returns a number rounded to a certain number of digits after the decimal point.

Syntax of Oracle/PLSQL function ROUND (for numbers)

ROUND( number_id, [ decimal_places_id ] ) )

Parameters and function arguments

• a number_id for rounding off.
• decimal_places_id – the number of decimal digits for rounding. This value must be an integer. If this parameter is not specified, the ROUND function will round the number to the nearest integer.

The ROUND function (for numbers) returns a numeric value.

The ROUND function can be used in the following versions of Oracle/PLSQL

Let’s consider some examples of the ROUND function and learn how to use the ROUND function in Oracle/PLSQL.

SELECT ROUND(123.456) FROM DUAL;

--Result: 123

SELECT ROUND(123.456, 0) FROM DUAL;

--Result: 123

SELECT ROUND(123.456, 1) FROM DUAL;

--Result: 123.5

SELECT ROUND(123.456, 2) FROM DUAL;

--Result: 123.46

SELECT ROUND(123.456, 3) FROM DUAL;

--Result: 123,456

SELECT ROUND(-123.456, 2) FROM DUAL;

--Result: -123.46

About Enteros

​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.