Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 111 of 177
sign::=
SIGN
returns -1 if n
<0, then . If n
=0, then the function returns 0. If n
>0, then SIGN
returns 1.
The following example indicates that the function's argument (-15) is <0:
SELECT SIGN(-15) "Sign" FROM DUAL; Sign ---------- -1
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|