Oracle Exam 1Z0-770 Topic 1 Question 4 Discussion

Collections are temporary tables that store session-specific data in memory. They can be used for various purposes in APEX applications. Some uses of collections are:

You insert, update, and delete collection information using PL/SQL API APEX_COLLECTION. This API provides several procedures and functions to manipulate collections and their members.

Use collections to temporarily capture one or more nonscalar values. For example, you can use collections to store the results of a query, the values of page items, or the selections of a report.

Collections can be accessed, manipulated, or processed during a user's specific session. For example, you can use collections to pass data between pages, perform calculations on collection members, or create reports based on collections.

Collections do not enable you to store rows and columns in the current session into database tables. Collections are stored in memory and are not persistent across sessions.