Oracle Application Express (APEX) 19.2

Create an apex application with app builder, then build a department form and a form with an interactive report, and run, update, and delete records.

Build a master-detail page in Oracle APEX 19.2, linking departments to employees with explicit relations, enabling adding, duplicating, and deleting department rules and viewing employee lists.

Compare classic and interactive reports in Oracle APEX 19.2, using interactive grids and charts; learn features like filtering, aggregates, display order, and optional data modification with insert, update, and delete.

Create and attach a navigation menu in an APEX application, add items for forms, reports, and master-detail pages, and verify navigation by opening department and report pages.

Learn to create a tree region in Oracle APEX 19.2, display an employee hierarchy, and navigate between a home page and a tree page using a navigation menu.

Learn how list of values in Oracle APEX 19.2 streamlines department data entry by selecting a manager and location from lists, returning IDs and displaying names.

Create a form and report pages in Oracle APEX for the employee table. Implement a boolean validation function and a salary-based commission computation.

Create dynamic actions in Oracle APEX 19.2 by wiring events such as click, change, double-click, and focus to trigger true actions, including JavaScript and SQL executions, in the app.

Learn to integrate JavaScript in APEX 19.2 to enhance application functionality by adding scripts to regions, headers, and page load events.