How can use Apex Collection In Oracle Apex

Insert Data Into Apex Collection :

begin

if not apex_collection.collection_exists('EMPLOYEE_COLLECTION') then

apex_collection.create_collection('EMPLOYEE_COLLECTION');

end if;

apex_collection.add_member (

p_collection_name=>'EMPLOYEE_COLLECTION',

p_c001=>:P2_EMPLOYEE_ID,

p_c002=>:P2_EMPLOYEE_NAME,

p_c003=>:P2_FATHERS_NAME,

p_c004=>:P2_MOTHERS_NAME,

p_c005=> :P2_DESIGNATION

);

end;

Data Show Into Report From Apex Collection :

SELECT SEQ_ID,c001 EMPLOYEE_ID,c002 EMPLOYEE_NAME,c003 FATHERS_NAME,c004 MOTHERS_NAME,c005 DESIGNATION 

from APEX_COLLECTIONS where COLLECTION_NAME='EMPLOYEE_COLLECTION' ; 

 

Insert Data Into Database From Apex Collection : 

IF apex_collection.collection_exists('EMPLOYEE_COLLECTION') THEN

DECLARE

VID NUMBER;

 BEGIN

  

    INSERT INTO EMPLOYEE_DETAILS(EMPLOYEE_ID,EMPLOYEE_NAME,FATHERS_NAME,MOTHERS_NAME,DESIGNATION)

    SELECT c001,c002,c003,c004, c005 FROM  APEX_COLLECTIONS where COLLECTION_NAME='EMPLOYEE_COLLECTION';

END;

    begin

    apex_collection.delete_collection(p_collection_name =>'EMPLOYEE_COLLECTION');

    end;

   

END IF;

Delete Apex Member From Apex Collection : 

if  apex_collection.collection_exists('EMPLOYEE_COLLECTION') then

begin

    APEX_COLLECTION. DELETE_MEMBER( p_collection_name => 'EMPLOYEE_COLLECTION' , p_seq =>:P2_SELECTED_ID);

end;

end if;