Lida Gholizadeh

Oracle Application Express (APEX) Collections are a powerful feature that enables developers to manage temporary, session-level data within their applications. This Article discusses about below subjects: What Are APEX Collections? Why should we not use the Database's temp table instead of APEX Collections?  Structure of APEX Collections Lifecycle of an APEX Collection APEX Collection APIs When Should You Think About Using APEX Collections? What Are APEX Collections? Oracle APEX (Application Express) Collections are versatile, session-specific, in-memory data structures designed for temporary data storage and manipulation during a user's session. They function similarly to database tables but do not persist in the database, making them ideal for transient data needs. APEX Collections enable data sharing across pages within the same session, support efficient batch processing of large datasets, and allow data manipulation using PL/SQL procedures, making them valuable for multi-s...

  Why should we not use the Database's temp table instead of APEX Collections?  If you want to know more about the APEX Collections I suggest you read the article below link:  https://lidagholizadeh.blogspot.com/2024/04/apex-collection.html What are Oracle Temporary Tables? Oracle Temporary Tables are database tables specifically designed to store temporary data for the duration of a session or transaction. The data in these tables is private to the session and is automatically removed either at the end of the transaction or the session, depending on how the table is defined. These tables are useful for scenarios where intermediate data needs to be stored and processed without being persisted permanently in the database. CREATE GLOBAL TEMPORARY TABLE TEMP_INVOICE_DETAILS ( ITEM_ID NUMBER, ITEM_NAME VARCHAR2( 100 ), QUANTITY NUMBER, PRICE_PER_UNIT NUMBER, DISCOUNT NUMBER, TOTAL_PRICE NUMBER ) ON COMMIT DELETE ROWS ; -- Data is cleared after ea...