Name
SIGN
Synopsis
The SIGN function returns the sign of the input number. The specification for the SIGN function is:
FUNCTION SIGN (n
NUMBER) RETURN NUMBER;
This function returns one of these three values:
-1 |
n is less than zero |
0 |
n is equal to zero |
+1 |
n is greater than zero |
Get Oracle PL/SQL Programming, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.