SIGN

Syntax

Purpose

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

Example

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

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