Oracle/PLSQL: TRUNC Function (with numbers)
This Oracle tutorial explains how to use the Oracle/PLSQL TRUNC function with syntax and examples.
Description: The Oracle/PLSQL TRUNC function returns a number truncated to a certain number of decimal places.
Syntax (with numbers) : The syntax for the TRUNC function in Oracle/PLSQL is:
TRUNC( number [, decimal_places] )
Parameters or Arguments : number
The number to truncate.decimal_placesOptional. The number of decimal places to truncate to. This value must be an integer. If this parameter is omitted, the TRUNC function will truncate the number to 0 decimal places.
The TRUNC function can be used in the following versions of Oracle/PLSQL:
(*)Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
Example: (with numbers)
Let us look at some Oracle TRUNC function examples and explore how to use the TRUNC function in Oracle/PLSQL.
For example: