Oracle/PLSQL: Sign Function:
[url]http://www.techonthenet.com/oracle/functions/sign.php[/url]
[quote]
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.
[/quote]
[url]http://www.techonthenet.com/oracle/functions/sign.php[/url]
[quote]
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.
[/quote]