🧩 What Is an APEX Collection?
🧩 What Is an APEX Collection? An APEX Collection is like a temporary in-memory table that stores data only for the current APEX session. It’s perfect when you need to: Capture user input temporarily. Avoid creating a real database table. Process, review, or update data before saving it permanently. Stored inside the built-in view: sql APEX_COLLECTIONS 🧱 The Structure of a Collection Each collection has: Type Columns Example Character 50 (C001–C050) Names text data Number 50 (N001–N050) IDs prices Date 5 (D001–D005) Dates CLOB 1 (CLOB001) Long text BLOB 1 (BLOB001) Images/files ✅ So, max 106 usable ...
