Collections enable you to temporarily capture one or more nonscalar values. You can use collections to store rows and columns currently in session state so they can be accessed, manipulated, or processed during a user's specific session. You can think of a collection as a bucket in which you temporarily store and name rows of information.

• About the APEX_COLLECTION API
  
• ADD_MEMBER Procedure
  
• ADD_MEMBER Function
  
• ADD_MEMBERS Procedure
  
• COLLECTION_EXISTS Function
  
• COLLECTION_HAS_CHANGED Function
  
• COLLECTION_MEMBER_COUNT Function
  
• CREATE_COLLECTION Procedure
  
• CREATE_COLLECTION_FROM_QUERY Procedure
  
• CREATE_COLLECTION_FROM_QUERY2 Procedure
  
• CREATE_COLLECTION_FROM_QUERY_B Procedure
  
• CREATE_COLLECTION_FROM_QUERY_B Procedure (No bind version)
  
• CREATE_COLLECTION_FROM_QUERYB2 Procedure
  
• CREATE_COLLECTION_FROM_QUERYB2 Procedure (No bind version)
  
• CREATE_OR_TRUNCATE_COLLECTION Procedure
  
• DELETE_ALL_COLLECTIONS Procedure
  
• DELETE_ALL_COLLECTIONS_SESSION Procedure
  
• DELETE_COLLECTION Procedure
  
• DELETE_MEMBER Procedure
  
• DELETE_MEMBERS Procedure
  
• GET_MEMBER_MD5 Function
  
• MERGE_MEMBERS Procedure
  
• MOVE_MEMBER_DOWN Procedure
  
• MOVE_MEMBER_UP Procedure
  
• RESEQUENCE_COLLECTION Procedure
  
• RESET_COLLECTION_CHANGED Procedure
  
• RESET_COLLECTION_CHANGED_ALL Procedure
  
• SORT_MEMBERS Procedure
  
• TRUNCATE_COLLECTION Procedure
  
• UPDATE_MEMBER Procedure
  
• UPDATE_MEMBERS Procedure
  
• UPDATE_MEMBER_ATTRIBUTE Procedure Signature 1
  
• UPDATE_MEMBER_ATTRIBUTE Procedure Signature 2
  
• UPDATE_MEMBER_ATTRIBUTE Procedure Signature 3
  
• UPDATE_MEMBER_ATTRIBUTE Procedure Signature 4
  
• UPDATE_MEMBER_ATTRIBUTE Procedure Signature 5
  
• UPDATE_MEMBER_ATTRIBUTE Procedure Signature 6