In Oracle, use SIGN function to check if the number is negative, zero or positive. Below is an example to how to check if the number is negative in Oracle.
Syntax
SIGN (n)
SIGN Function Example
SET SERVEROUTPUT ON; DECLARE n NUMBER := -5; BEGIN IF SIGN (n) < 0 THEN DBMS_OUTPUT.put_line ('Number is negative.'); ELSIF SIGN (n) = 0 THEN DBMS_OUTPUT.put_line ('Number is zero.'); ELSE DBMS_OUTPUT.put_line ('Number is positive.'); END IF; END; /
Output
Number is negative. PL/SQL procedure successfully completed.