Databases Reference
In-Depth Information
WHERE delete flag IS NULL
This condition will exclude those records from the collection that are marked as deleted.
You will create a select list within the Tabular Form region:
P3 DEPTNO
. This select list will show a list
of available departments based on the SQL query:
SELECT dname, deptno
FROM dept
You will also need a button displayed after the select list (create a button displayed among this
region's items) which you will use to trigger the process. Name this button
P3 GO
and assign it a request
GO
.
Now you can start creating a page process (Create Collection) on submit for creating a collection.
You will use the following PL/SQL block for this:
BEGIN
tab form emp pkg.create emp collection (:p3 deptno, :t message);
END;
Make the block conditional to run based on the following PL/SQL Expression:
:REQUEST IN ('GO')
Do not forget to code the following as the success message of the process:
&T MESSAGE.
Finally, everything is set for testing what you have done. If you select the sales department from the
list and press the GO button, you should get a result similar to the one shown in Figure 3-27.
Figure 3-27.
Tabular Form on APEX Collection
The question now is, how do you update your collection? Following are three possible methods for
updating the collection:
