Oracle TRUNC function (FOR NUMBER).

Preamble

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

Oracle/PLSQL syntax of TRUNC function

TRUNC( number_id, [ decimal_places_id ] ) )

Parameters and function arguments

• number_id – number for truncation.
• decimal_places_id – is the number of decimal digits for truncation. This value must be an integer number. If this parameter is not specified, the TRUNC function will return an integer number. If the parameter is negative, the numbers to the left of the decimal point will be truncated.

The TRUNC function (for numbers) returns a numerical value.

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

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

SELECT TRUNC(123.456) FROM DUAL;

--Result: 123

SELECT TRUNC(123.456, 0) FROM DUAL;

--Result: 123

SELECT TRUNC(123.456, 1) FROM DUAL;

--Result: 123,4

SELECT TRUNC(123.456, 2) FROM DUAL;

--Result: 123,45

SELECT TRUNC(123.456, 3) FROM DUAL;

--Result: 123,456

SELECT TRUNC(-123.456, 2) FROM DUAL;

--Result: -123.45

SELECT TRUNC(123.456, -1) FROM DUAL;

--Result: 120

SELECT TRUNC(123.456, -2) FROM DUAL;

--Result: 100

SELECT TRUNC(123.456, -3) FROM DUAL;

--Result: 0

Oracle Tutorial; Date Functions ROUND and TRUNC

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.​