Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

Use SIGN in PLSQL 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>