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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.