SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 30

Output:

New Year
---------
01-JAN-92

Numeric Functions:

The following functions fall under this category.

ABS ROUND

SIGN TRUNC

CEIL SQRT

FLOOR MOD

Example:

SELECT ABS(-25) "Result"
FROM DUAL;

Output:

Result
----------
25

Example:

SELECT SIGN(-15) "Result"
FROM DUAL;

Output:

Result
----------
-1