Use SIGN in PL/SQL statement : SIGN « Numeric Math Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Numeric Math Functions
3. SIGN

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>

 

Related examples in the same category