Oracle Application Express - APEX- Crash Course

Create a form in Oracle APEX by selecting form, choosing a data source (table or SQL), setting the primary key, and deploying the page to enter or update data.

Create a blank page in Oracle APEX, add a static content region with user id, user name, and email fields, and a button that alerts entered data.

Create a tree page in Oracle APEX using a self-referential employees table to show manager hierarchies with node text and tooltip.

Explore creating and using page items and application items in Oracle APEX, including components like text fields and date pickers, lists of values, and dynamic show/hide behavior.

Master detail form in Oracle APEX demonstrates stacked, side-by-side, and drill-down layouts, using master and child tables with DML operations and interactive grids.

Explore Oracle APEX page modes: normal, modal dialog, and non modal dialog. Learn how modal dialog grays out the parent page while non modal keeps it active.

Explore how Oracle APEX defines and builds reports from SQL queries or tables, and compare classic, interactive, interactive grid, faceted search, and card reports, with a hands-on creation demo.

Explore interactive reports in Oracle APEX, including aggregation, compute, highlight, and pivot. Learn to create an interactive report from a table or query, customize layout, and save reports.

Master interactive grid in Oracle APEX by performing CRUD operations, applying control break, and building charts, guided by setup steps from login to selecting a table or SQL source.

Explore faceted search in Oracle Apex by building a page with searchable criteria and facets, using checkbox and range filters, data sources, and display options.

Discover how to display multiple charts on a page in Oracle APEX by building a dashboard with a static content region and configuring the faceted search region to show charts.

Explore restful data sources in Oracle APEX, creating auto and manual REST APIs, with GET, POST, PUT, and DELETE operations, tested via Postman on DPT and EMP tables.

Explore dialog pages in Oracle APEX, including modal and non modal dialogs, their design steps, testing, and how to set targets and page modes within a typical APEX hierarchy.

Explore themes and templates in Oracle APEX, learning how a theme packages templates to style pages. Create custom templates and apply CSS to buttons and components.

Learn globalization and translation in Oracle APEX by defining application language, seeding translatable text, updating Excel/XLIFF translations, and publishing localized apps.

Upload and organize static application files in Oracle APEX, then reference them as hyperlinks or embedded images using app_files and directory paths.

Learn to create a funnel chart in Oracle APEX by selecting the chart component, choosing funnel type, and configuring data source, orientation, and series mapping.

Learn to create an Oracle APEX calendar page from a table or SQL query with start and end dates. Enable drag‑and‑drop and CSS classes to reflect status, and reuse forms.

Learn how to view and run the advisor in Oracle Apex from application utilities or page designer, perform checks, and interpret warnings across your app for security and quality.

Learn how to create an Apex workspace in Autonomous DB, navigate manage workspaces, set up a new workspace with a database username and password, and launch a Hello World app.

Learn how breadcrumbs guide users in oracle apex, then create them automatically with the page wizard or manually via shared components or page designer, including parent entities and multiple levels.

Master apex collections, a session-scoped, non-scalar data type in Oracle APEX. Use apex_collection APIs to create, read, update, and delete in-session data similar to a temporary in-session storage.

Load data into Oracle APEX tables using the data loader wizard, supporting CSV, XLS, XML, and JSON formats with source-to-target mapping, error handling, and append, merge, or replace options.

Explore the Apex data parser API to load csv, xml, json, and xls/x data from blob content, discover file profiles, and parse dynamic columns for temp table loading.

Master dynamic action functionality in Oracle APEX by applying client-side validations, enabling and disabling elements, hiding and showing regions, and setting values with PL/SQL.

Explore sending emails in Oracle APEX using the apex_mail.send API or the send email process, including from address, to address, cc, subject, body, HTML content, and attachments.

Learn how to implement file upload and download in Oracle APEX, using blob columns, mime types, display image and download blob in classic reports, and file browse upload.

Learn how to use navigation list, navigation menu, and navigation bar in Oracle APEX, configure them under application shared components, and create and organize entries for custom pages.

Learn how Oracle APEX can generate a table based PL/SQL API with CRUD methods (get, insert, update, delete), then integrate and customize it in a report-with-form app.

Learn to enable and implement the feedback feature in Oracle APEX, create a feedback page, configure navigation and administration preferences, view user responses, and remove the feature when needed.

Learn to implement Oracle APEX print reports with generic and named column layouts, define report queries, and generate pdf attachments, including templates designed with the by publisher plugin.

Learn to create a wizard page in Oracle APEX, building a multi-step, interactive flow with steps, navigation, and content regions like interactive grids and forms.

Fetch the current logged-in user via the apex__custom__authentication.dot_get_username API and validate usernames against the Apex workspace_apex_users table, updating a validity flag and enabling a switch.

Explore how the SIS.HTTP.P package enables dynamic HTML generation in Oracle APEX using PL/SQL, generating tables, text areas, inputs, and other HTML content at runtime.

Create files from sql queries in Oracle APEX using the Apex data export package to generate csv and zip outputs, including blob handling and download steps.

Learn to run long-running PL/SQL in Oracle APEX using an execution chain with run in background, and monitor status via process history and execution IDs.

Learn how to upload files to OCI object storage from Oracle APEX. List buckets and objects, configure OCI credentials, and use REST data sources and PL/SQL APIs for uploading.

Configure a Cohere LLM in Oracle APEX via workspace utilities, then create apps and SQL queries using JNI and the generative AI assistant to generate and refine pages.

Explore how to show an ai assistant and generate text with generative ai in oracle apex, configuring ai services and wiring inputs, outputs, and dynamic actions.