SELECT n001, n002, n003, c001, c002, c003, c004 FROM APEX_COLLECTIONS WHERE COLLECTION_NAME = 'EMPLOYEE'

BEGIN
   APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION (p_collection_name => 'EMPLOYEE');
      
   FOR i IN 1 .. APEX_APPLICATION.G_F02.COUNT
   LOOP
      APEX_COLLECTION.ADD_MEMBER (p_collection_name   => 'EMPLOYEE',
                                  p_n001              => APEX_APPLICATION.G_F02 (i),
                                  p_n002              => APEX_APPLICATION.G_F03 (i),
                                  p_n003              => APEX_APPLICATION.G_F04 (i),
                                  p_c001              => APEX_APPLICATION.G_F05 (i),
                                  p_c002              => APEX_APPLICATION.G_F06 (i),
                                  p_c003              => APEX_APPLICATION.G_F07 (i),
                                  p_c004              => APEX_APPLICATION.G_F08 (i));                               
   END LOOP;
END;