Oracle Forms and Reports 12c

Build a data block and form components in Oracle Forms 12c; connect to database. Demonstrate running the form in two ways: standalone and without a browser.

Explore how to implement triggers at form, data block, and item levels and configure alerts with display messages, while noting the default editor is sufficient.

Create record groups and lovs for location_id and manager_id, replacing manual entry with dropdowns. Learn to map return items and display lists in Oracle Forms.

Master-detail relationships connect departments as the master block to employees as the detail block using a department id foreign key to enforce one-to-many data relationships and build a functional form.

Learn how to create a PL/SQL library to house reusable program units and functions, attach it to a form, and share logic across multiple Oracle forms.