The setup and the page used in this tutorial are the same as in my previous article ( Super Dynamic APEX Forms Using APEX_ITEM and Dynamic Actions), and this article can be considered the second part of that one. In this tutorial, I will build a collection from the data stored in a table, add more rows from the table to the existing collection, and then I will show you how to add new member to the collection, how to edit a Member, how to delete a member, and how to save the collection back to the table. I will use some simple Dynamic SQL, and we will use dynamic actions too (many of them actually!). Each member has a sequence number and each collection must have a unique name. Each Apex Collection can can has 50 varchar2 attributes (c001 -> c0050), 5 number Attributes (n001->n005), 5 date attributes (d001->d005), 1 CLOB attribute (clob001), and 1 BLOB Attribute (blob001). This data can be manipulated in any way and then stored in Table(s). It can be used in many ways for different purposes, but in general, you can think of Apex Collection as a temporary space to store complex data Types - non-scalar - for instance, full row of data from a table or a view (When you work with Apex Temporary table is not a real option). Apex Collections (APEX_COLLECTION) is a package that comes with Oracle Apex and is one of the most important features that comes with Oracle APEX.
0 kommentar(er)
