Cacher is the code snippet organizer for pro developers

  if apex_collection.collection_exists (p_collection_name => p_collection_name)
  then
    apex_collection.delete_collection(p_collection_name => p_collection_name);
  end if;

  --apex_collection.create_collection(p_collection_name => p_collection_name);
  
  
  /*l_sql :=
    q'[select *
         from tmp_tbl_articulos
           where country_iso_code = :COUNTRY_CODE]';

  apex_collection.create_collection_from_query_b
  (
      p_collection_name => p_collection_name
    , p_query           => l_sql
    , p_names           => apex_util.string_to_table('COUNTRY_CODE')
    , p_values          => apex_util.string_to_table(p_holiday_country_code)
  );
*/



select seq_id,
    c001,
    c002,
    c003,
    c004,
    c005
  from apex_collections
  where collection_name = 'DATA_COLLECTION'
  


apex_collection.delete_member( p_collection_name => p_collection_name
                             , p_seq => p_seq_id
                ); 

apex_collection.add_member (
       p_collection_name => p_col_name
    ,  p_c001 => null
    ,  p_c002 => l_oum
    ,  p_c005 => 0
    ,  p_c010 => p_wdrw_brand
    ,  p_c015 => p_sku 
);

***
create or replace view isc_tag_collection
as
select 1 from dual


*

    APEX_COLLECTION.UPDATE_MEMBER (
        p_collection_name => 'Departments',
        p_seq => '2',
        p_c001 => 'Engineering',
        p_c002 => 'Sales');