\begin{verbatim}
INSERT INTO Organization_ObjTab
 (SELECT Organization_Type (Name, Abbreviation, NULL, Established, NULL)
  FROM Organization);
\end{verbatim}

\begin{verbatim}
CREATE OR REPLACE PROCEDURE Insert_All_Members IS
BEGIN
 FOR mship IN (SELECT * FROM isMember)
 LOOP makeMember(mship.organization, mship.country, mship.type);
 END LOOP;
END;
/
EXECUTE Insert_All_Members;
\end{verbatim}

\begin{sql}
UPDATE {\red  Organization\_ObjTab org} \\
SET hasHqIn =  \\
\>(\>SELECT REF({\blue cty}) \\
\>\>   FROM {\blue ORCity cty}, {\magenta Organization old} \\
\>\>   WHERE {\red  org.Abbrev} = {\magenta old.Abbreviation} \\
\>\>     AND {\blue cty.Name} = {\magenta old.City} AND {\blue cty.Province} = {\magenta old.Province}
        AND {\blue cty.Country} = {\magenta old.Country});
\end{sql}