9 APEX_COLLECTION

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
  
• Naming Collections
  
• Creating a Collection
  
• About the Parameter p_generate_md5
  
• Accessing a Collection
  
• Merging Collections
  
• Truncating a Collection
  
• Deleting a Collection
  
• Deleting All Collections for the Current Application
  
• Deleting All Collections in the Current Session
  
• Adding Members to a Collection
  
• About the Parameters p_generate_md5, p_clob001, p_blob001, and p_xmltype001
  
• Updating Collection Members
  
• Deleting Collection Members
  
• Obtaining a Member Count
  
• Resequencing a Collection
  
• Verifying Whether a Collection Exists
  
• Adjusting a Member Sequence ID
  
• Sorting Collection Members
  
• Clearing Collection Session State
  
• Determining Collection Status
  
• ADD_MEMBER Procedure
  
• ADD_MEMBER Function
  
• ADD_MEMBERS Procedure
  
• COLLECTION_EXISTS Function
  
• COLLECTION_HAS_CHANGED Function
  
• COLLECTION_MEMBER_COUNT Function
  
• CREATE_COLLECTION Procedure
  
• CREATE_OR_TRUNCATE_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)
  
• 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