Answers for "oracle apex_collection delete members example"

SQL
2

oracle apex collection delete member

BEGIN
    APEX_COLLECTION.DELETE_MEMBER(
        p_collection_name => 'EMPLOYEES_CL',
        p_seq => '2');	-- sequence ID of the collection member to be deleted

	-- Deletes all members having 'ADMIN' for attr n°5
    APEX_COLLECTION.DELETE_MEMBERS(
            p_collection_name => 'EMPLOYEE_CL',
            p_attr_number => 5,
            p_attr_value => 'ADMIN');
END;
Posted by: Guest on July-14-2021
3

oracle apex delete collections

BEGIN
    APEX_COLLECTION.DELETE_COLLECTION(p_collection_name => 'EMPLOYEE_CL');
    -- All collections belonging to current session
    APEX_COLLECTION.DELETE_ALL_COLLECTIONS_SESSION;
    -- All collections belonging to current user
    APEX_COLLECTION.DELETE_ALL_COLLECTIONS;
END;
Posted by: Guest on July-14-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language