IF statement with number value check : Number « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. Number

SQL>
SQL>
SQL> DECLARE
  2    a number :=50;
  3    b number :=-20;
  4  BEGIN
  5    IF (a>b)THEN
  6
  7      dbms_output.put_line('A is greater than B');
  8
  9    ELSIF (a<b)THEN
 10
 11      dbms_output.put_line('A is < than B');
 12
 13    ELSE
 14
 15      dbms_output.put_line('A is equal to B');
 16
 17    END IF;
 18  END;
 19  /
A is greater than B

PL/SQL procedure successfully completed.

SQL>