|
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>
|