Answers for "oracle apex collection add"

oracle apex collection add element

BEGIN
  APEX_COLLECTION.ADD_MEMBER(
          P_COLLECTION_NAME => 'EMPLOYEE_COLLECTION',
          P_C001 => :P2_EMP_NO,
          P_C002 => :P2_EMP_NAME
      );
END;

oracle apex collection add element

DECLARE
    CURSOR c_emp IS
        SELECT EMP_NO, EMP_NAME FROM EMP;
BEGIN
    IF NOT APEX_COLLECTION.COLLECTION_EXISTS('EMPLOYEE_COLLECTION')
    THEN APEX_COLLECTION.CREATE_COLLECTION('EMPLOYEE_COLLECTION');
    ELSE APEX_COLLECTION.TRUNCATE_COLLECTION('EMPLOYEE_COLLECTION');
    END IF;

    FOR c IN c_emp
        LOOP
            APEX_COLLECTION.ADD_MEMBER(P_COLLECTION_NAME => 'EMPLOYEE_COLLECTION',
                                       P_C001 => c.EMP_NO,
                                       P_C002 => c.EMP_NAME
                );
        END LOOP;
END;