Oracle/PLSQL: Sign Function

In Oracle/PLSQL, the sign function returns a value indicating the sign of a number.

The syntax for the sign function is:

sign( number )

number is the number to test for its sign.

If number < 0, then sign returns -1.
If number = 0, then sign returns 0.
If number > 0, then sign returns 1.

Applies To:

• Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

sign(-23)	would return -1
sign(-0.001)	would return -1
sign(0)	would return 0
sign(0.001)	would return 1
sign(23)	would return 1
sign(23.601)	would return 1