Mega Code Archive
Categories
/
Oracle PLSQL
/
Numeric Math Functions
-SIGN(x)
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) ---------- -1 SQL>