\begin{sql}
MEMBER FUNCTION numberOfMembers RETURN NUMBER \\
IS \\
BEGIN \\
\>  {\blue IF SELF.Members IS NULL THEN RETURN 0}; END IF; \\
\>  RETURN Members.COUNT; \\
END; \\[0.2cm]
MEMBER PROCEDURE addMember  \\
\>\>   (the\_country IN VARCHAR2, the\_type IN VARCHAR2) IS \\
BEGIN \\
\> IF NOT SELF.isMember(the\_country) = 'no' \\
\>\> THEN RETURN; END IF; \\
\>  \blue IF SELF.Members IS NULL THEN  \\
\>\> \blue UPDATE Organization\_ObjTab \\
\>\> \blue SET Members = Member\_List\_Type() \\
\>\> \blue WHERE Abbrev = SELF.Abbrev;  \\
\>\blue  END IF;   \\
\>  INSERT INTO \\
\>  THE (SELECT Members  \\
\>\>             FROM Organization\_ObjTab org  \\
\>\>             WHERE org.Abbrev = SELF.Abbrev) \\
\>  VALUES (the\_country, the\_type); \\
END; \\
END; \\
/
\end{sql}
