Example 1: Using an IF control statement

    IF (SELECT COUNT (*) FROM STUDENTS
               WHERE CLASS = :CLASS_NUM)
         > 30

       THEN
          SET :MSG = 'Class is too large.';
       ELSE
          SET :MSG = 'Class size is O.K.';

    END IF;