ORA-00001: Unique constraint violated

   I'm writing a short blog post today as part of the Joel Kallman Day 2025 . Oracle Database Express Edition (XE) is the free edition o...

 I'm writing a short blog post today as part of the Joel Kallman Day 2023 . Some time ago (I think it was around the APEX v20.1 release)...

 When running Oracle Application Express (APEX) in production, the best practice is to deploy the "Runtime-Only" environment, inst...

There's a new version of Oracle Application Express (APEX) in town, and one of the new "features" is a new region type called...

 I'm writing a short blog post today as part of the Joel Kallman Day . "Server-Side Caching" is probably an under-utilized fea...

The "Oracle Tech Network Appreciation Day" has been renamed to " Joel Kallman Day " in honor of Joel Kallman, who along ...

Today it's exactly ten years since I published my blog post called Mythbusters: Stored Procedures Edition .  Using "stored procedur...

The Oracle Application Express (APEX) documentation summarizes the translation process thus: "To translate an application developed i...

When you create an application in Oracle Application Express (APEX) using the Universal Theme, the application comes with a few default ...

Oracle APEX has a built-in Dynamic Action called "Execute PL/SQL Code" that executes a block of PL/SQL code on the server via an A...

Maybe you've heard about " Quick SQL ", a utility (previously a separate application, now part of APEX 18.1 itself) that gener...

The APEX_UTIL package in Oracle Application Express is a mixed bag of "miscellaneous" stuff. From the documentation : " You...

In the upcoming Oracle Application Express (APEX) 5.2 release, support has been added for so-called "Social Sign-In" authenticatio...

I was looking at the GitHub "contribution chart", which shows number of commits per day as a heatmap calendar. I thought this type...

After installing APEX 5.0.4 and ORDS 3.0.8 I had an issue where APEX plugins that have static files bundled with the plugin (files that at ...

Tim Hall of oracle-base.com fame suggested we should all do an "OTN Appreciation" day in honor of the Oracle Technology Network (...

APEX 5 has built-in support for dialog boxes. These come in two varieties; dialog pages (which show another standard APEX page in a dialog b...

Just a quick note about an error I encountered when importing an old Apex 3.2 (!) app into Apex 5.0.2. Using Apex 5.0.2, I have imported ...