SIGN

Syntax

sign::=

Text description of sign

Purpose

If n<0, SIGN returns -1. If n=0, the function returns 0. If n>0, SIGN returns 1.

Example

The following example indicates that the function's argument (-15) is <0:

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

      Sign
----------
        -1