Hands-on Practice: Complete the Edit Page

You start adding components to the Edit page by dropping in an ADF Form based on AllEmployees. The AllEmployees view object represents a query that joins EMPLOYEES and EMPLOYEES (for the manager) tables and also joins the EMPLOYEES and DEPARTMENTS tables. Because the EMPLOYEES (managers) and DEPARTMENTS tables were marked as reference only, ADF BC will not issue INSERT, UPDATE, or DELETE statements to those tables.

This is comparable to the behavior we would see if this query were a database view; we would only be able to update columns in the base table (EMPLOYEES), not columns in the lookup tables (EMPLOYEES, for managers, and DEPARTMENTS).

This hands-on practice follows these phases:

I. Prepare the ...

Get Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.