INSERT INTO Organization_ObjTab
 (SELECT Organization_Type
     (Name, Abbreviation, NULL, Established, NULL)
  FROM Organization);

CREATE OR REPLACE PROCEDURE Insert_All_Members IS
BEGIN
 FOR the_membership IN
     (SELECT * FROM isMember)
 LOOP make_member(the_membership.organization,
                  the_membership.country,
                  the_membership.type);
 END LOOP;
END;
/
EXECUTE Insert_All_Members;

UPDATE Organization_ObjTab org
SET hasHqIn =
 ( SELECT REF( cty)
     FROM ORCity cty,  Organization old
     WHERE org.Abbrev = old.Abbreviation
       AND cty.Name = old.City
       AND cty.Province = old.Province
       AND cty.Country = old.Country);
