SQL> --SIGN(x): Returns -1 if x is negative, 1 if x is positive, or 0 if x is zero.SQL>SQL> select SIGN(-5) from dual; SIGN(-5)---------- -1SQL>