PL/SQL If-Then-Else Statement

Oracle PL/SQL allow the following statements: if, if else, if elsif.

if - then

If a = 5 Then
   ...
End If;

if - then - else

If b = 10 Then
   ...
Else
   ...
End If;

if - then - elsif

If c = 15 Then
   ...
ElsIf c = 16 Then
   ...
Else
   ...
End If;


Example:

DECLARE
  c varchar2(30);
BEGIN
  IF c IS NULL THEN
    DBMS_OUTPUT.PUT_LINE('Value of c is null.');
  ELSE
    DBMS_OUTPUT.PUT_LINE('Value of c is not null.');
  END IF;
END;