
Learn JavaScript essentials for Oracle APEX, including jQuery basics, ajax callbacks, and dynamic actions, then apply JavaScript to open modal dialogs and customize interactive grids.
Build on your existing Oracle APEX knowledge to expand techniques for creating and running advanced applications. Familiarize yourself with fundamentals and JavaScript basics, including variables and functions.
Learn how to request and activate a new free Oracle APEX workspace on apex.oracle.com, including creating an account, receiving the activation link by email, and signing into a fresh environment.
Install the Oracle APEX sample datasets in SQL workshop, creating tables for customers, stores, products, and orders, then refresh the object browser to confirm installation before building pages from scratch.
Create a new Oracle APEX application with sample tables, configure sign-in or no authentication, set a home page and global region, and run the boilerplate to explore pages.
Adapt to Oracle APEX 21.2 changes by using the left panel and layout or text modes to navigate regions, dynamic actions, page processing, and shared components.
Explore how Oracle APEX renders pages with HTML, CSS, and JavaScript, and learn to manipulate the DOM using JavaScript and jQuery to interact with APEX page items.
Explore the differences between JavaScript, jQuery, and APEX API for handling page item values in Oracle APEX, including selecting elements and using getValue and setValue.
Explore how to declare and define variables and functions at the page level in Oracle APEX, using global declarations, let and var, and page-load execution with console debugging.
Explore Oracle APEX dynamic actions that run JavaScript on events like change and click, using console.log debugging and execute JavaScript code to control page behavior.
Explore JavaScript initialization in Oracle APEX by using a callback function to customize interactive grid and column configurations, returning a config object and leveraging region and column level options.
Learn how ajax callback drives instant UI updates by sending http requests from JavaScript to an Oracle APEX pl/sql backend, which returns json or text data and refreshes the dom.
Define server logic with a PL/SQL ajax callback to fetch a customer's full name by id and render JSON via apex_json.write, updating the page without refresh.
Define client-side logic for an ajax callback, wiring a dynamic action on customer id changes, using apex.server.process with x01, and parse json to update P1_FULL_NAME.
Learn how to build an ajax callback in Oracle APEX to populate mail recipients from selected customers, using page items, dynamic actions, and a PL/SQL function to fetch emails.
Learn to create and invoke a modal dialog in Oracle APEX, compare modal and non-modal dialogs, and use a button on a normal page to open the dialog.
Open a modal dialog from a normal page by creating a form region bound to a stores query, then parse the store id to display details.
Open a modal dialog with dynamic data using an AJAX callback in Oracle APEX, and generate the dynamic URL with APEX_UTIL.PREPARE_URL. Use JavaScript to navigate via apex.navigation.redirect.
Enhance the security of modal dialogs by enforcing access control and using session-level, checksum-based protection for dynamic parameters via prepare_url and ajax, preventing tampering.
Learn to use Oracle APEX framework events such as after refresh, before refresh, before submit, and dialog closed through practical demos of dynamic actions, interactive grids, and modal dialogs.
Explore Oracle APEX component events and dynamic actions, focusing on the interactive grid selection change, row initialization, and after-save behavior to customize grid interactions.
Master a custom event in Oracle APEX dynamic actions by defining and triggering apex.event.trigger across the document, parsing this.data, opening modals, and wiring AJAX callbacks.
Attach browser events with JavaScript and jQuery, add click listeners to open a modal dialog via AJAX callbacks, and explore dynamic actions and event generalization.
Learn to customize the Oracle APEX interactive grid toolbar using JavaScript, define the config object, and add a custom button that opens a modal dialog for selected rows.
Define toolbar button actions in Oracle APEX's interactive grid by configuring initActions, mapping actions like add, disable, enable, and remove, and invoking a modal via a custom event.
Learn to customize Oracle APEX interactive grid actions by removing and adding toolbar items via toolbarData, and define select lists and menus with submenus and keyboard shortcuts.
Learn how to customize Oracle APEX interactive grids using JavaScript initialization, move the save button to the header, and invoke actions via apex.region, getActions, list, and invoke.
Define actions for the interactive grid’s selected records by building a modal dialog that shows chosen records, storing selections in an apex collection and using ajax to display them.
Explore client-side validations in Oracle APEX's interactive grid with HTML and apex APIs, including apex.item and setCustomValidity, plus modal validation, and learn when to prefer server-side checks.
Add row level actions to an interactive grid, open edits in a form via a modal, and listen to data changes with modal subscribe and getContextRecord.
Explore the apex.message API to display alerts, confirms, and custom dialogs, handle callbacks, and show success or error messages, including page and inline item level errors.
Explore the apex.page API in Oracle APEX, including submit actions, dynamic actions, showWait overlays, change tracking with apex.page.isChanged or apex.item.isChanged, and helpers like apex.page.confirm, apex.page.validate, and unsaved changes management.
Explore apex.util and the Oracle APEX JavaScript APIs to use arrayEqual, debounce, escapeHTML, and toArray for safer, efficient JavaScript development.
Celebrate completing the Oracle APEX advanced course and learn to use JavaScript APIs from the Oracle APEX documentation to customize and build up-to-date web applications using the latest technologies.
Oracle APEX is known for developing low-code enterprise applications.
But customization is something that might be needed with an additional code to work on the outputs we want.
So, JavaScript is the one that helps Oracle APEX as it is the front-end language on which Oracle APEX runs and it is very important to know the Oracle APEX provided JavaScript APIs. Hence it is necessary when it comes to customizing the component.
In this course, you will be learning JavaScript, starting from the basics and how it works in APEX Page Designer.
You will also learn how to refresh the data without reloading the page using AJAX Callback.
You will get to know the importance of AJAX Callback as part of Full-Stack Programming.
You will learn how to open a Modal Dialog with dynamic data using JavaScript.
Oracle APEX has Dynamic Actions as part of handling the events happening on the front end. Hence learning and implementing JavaScript has become a must here.
You will learn about various events in Dynamic Actions and also how to create a custom event.
You will get to know how to write JavaScript logic and avoid Dynamic Actions if necessary.
Finally, when it comes to the front end again, one of the real-time applications of Oracle APEX is the Interactive Grid where we have the option to do more customization.
You will learn about adding new toolbars to the Interactive Grid.
You will learn about the concept behind Interactive Grid toolbars which help you to understand how JavaScript really works in Oracle APEX.
This will lead you to learn more Oracle APEX OOTB JavaScript APIs which we will be covering some of the most used ones in this course.