APEX from the Field – Page 2 – APEX, PL/SQL and SQL

APEX | ORDS

Securing ORDS Endpoints with OAuth2
Bydenioflavio 02/16/202602/16/2026

In this article, I demonstrate how to secure ORDS REST endpoints using OAuth2 Client Credentials within Oracle APEX running on Autonomous Database (OCI). The post walks through creating roles and privileges via the APEX RESTful Services interface, configuring an OAuth client using SQL Workshop, and validating the full authentication flow using Postman. This example highlights machine-to-machine security architecture and best practices for protecting exposed ORDS APIs.

Read More Securing ORDS Endpoints with OAuth2
APEX

Refreshing Multiple Oracle APEX Regions with a Single Dynamic Action Using jQuery Selectors
Bydenioflavio 02/10/202603/04/2026

In this video, I demonstrate a practical Oracle APEX dashboard pattern that uses a single Dynamic Action combined with a jQuery selector to refresh multiple regions at once. The demonstration starts with a simple page containing filters and one report region refreshed by a button. As the page evolves into a real dashboard with multiple…

Read More Refreshing Multiple Oracle APEX Regions with a Single Dynamic Action Using jQuery Selectors
SQL

Updating XML Stored as CLOB in Oracle Using XMLQuery
Bydenioflavio 01/31/202602/03/2026

Using a simplified shopping cart XML example, the content shows how to safely modify an XML element while properly handling namespaces and following the required copy / modify / return pattern defined by the XQuery standard.

The example intentionally reflects real-world constraints, where the XML is already stored as CLOB and changing the data model to XMLTYPE is not an option. The focus is on clarity, maintainability, and correct usage of supported Oracle XML features rather than deprecated functions.

Read More Updating XML Stored as CLOB in Oracle Using XMLQuery