Use SIGN in PL/SQL statement
SQL> SQL> set serveroutput on SQL> SQL> BEGIN 2 DBMS_OUTPUT.PUT_LINE(SIGN(3.5)); 3 DBMS_OUTPUT.PUT_LINE(SIGN(-3.5)); 4 DBMS_OUTPUT.PUT_LINE(SIGN(0)); 5 END; 6 / 1 -1 0 PL/SQL procedure successfully completed. SQL> SQL>