\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 the_membership IN
     (SELECT * FROM is_member)
 LOOP make_member(the_membership.organization,
                  the_membership.country,
                  the_membership.type);
 END LOOP;
END;
/
EXECUTE Insert_All_Members;
\end{verbatim}

\begin{sql}
UPDATE {\red  Organization\_ObjTab org} \\
SET has\_hq\_in =  \\
\>(\>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}
