oracle apex collection delete member

Solutions on MaxInterview for oracle apex collection delete member by the best coders in the world

showing results for - "oracle apex collection delete member"
Luisa
03 Jan 2017
1BEGIN
2    APEX_COLLECTION.DELETE_MEMBER(
3        p_collection_name => 'EMPLOYEES_CL',
4        p_seq => '2');	-- sequence ID of the collection member to be deleted
5
6	-- Deletes all members having 'ADMIN' for attr n°5
7    APEX_COLLECTION.DELETE_MEMBERS(
8            p_collection_name => 'EMPLOYEE_CL',
9            p_attr_number => 5,
10            p_attr_value => 'ADMIN');
11END;
Niclas
06 Jun 2017
1BEGIN
2    APEX_COLLECTION.DELETE_COLLECTION(p_collection_name => 'EMPLOYEE_CL');
3    -- All collections belonging to current session
4    APEX_COLLECTION.DELETE_ALL_COLLECTIONS_SESSION;
5    -- All collections belonging to current user
6    APEX_COLLECTION.DELETE_ALL_COLLECTIONS;
7END;