I had been waiting for my Oracle APEX environment on OCI to be updated to version 26. This week it finally happened. So, to celebrate properly, I decided to build a small field-style demo around one of the features that immediately caught my attention in this release: native AI Agents in Oracle APEX. The interesting…
Most of the time, when I build an APEX page, I try to stay inside the declarative model for as long as the page still feels honest. Native regions, template components, lists, cards, reports, buttons, dynamic actions, and Universal Theme options are usually easier to maintain because they remain visible in the Builder and other…
User feedback has a bad reputation among developers. It arrives without reproduction steps. It calls an unclear label a bug and a business-rule disagreement a system failure. Sometimes it appears in a meeting three weeks after the user quietly found another way to finish the work. It is tempting to treat feedback as a necessary…
A deep dive into Oracle APEX URLs: request, clear cache, debug, Interactive Reports, authentication switching, session state, and secure URL generation. Understanding URL parameters changes how you design APEX applications.
In the first version of this case, I deliberately kept things focused. The goal was to prove that a user could come in through Google, complete a minimal onboarding flow, receive ORDS client credentials, and actually use those credentials against a protected endpoint. That loop, once it closes, already carries a lot of value, and…
In APEX, the usual paths are familiar: workspace users, database accounts, or some internal authentication model we control ourselves. But APEX also gives us Social Sign-In, and that changes the tone of the application completely. There are several ways to do that depending on the provider, but in this case I am using Google because…
A practical from-the-field test showing how Oracle 26ai annotations can reduce NL2SQL ambiguity by giving the database the business context that object names alone never carried.
A practical, from-the-field look at Oracle Assertions, showing how they can push real business rules like mandatory customer contact data and required justification for price reductions back into the schema in a more declarative way.
By Dênio Flávio Garcia da Silva I’ve spent a lot of time auditing APEX environments, and nothing sinalizes a maintenance nightmare quite like the “Hidden Item Explosion.” We’ve all been there: a simple form grows, logic accumulates, and suddenly you’re juggling dozens of values across multiple processes. It works, sure, but would you trust your future self…
By Denio Flavio Garcia da Silva After more than 15 years working with PL/SQL, I still managed to find a feature that genuinely surprised me. I ran into it while preparing for the PL/SQL certification exam (1z0-149), which was easily the hardest Oracle certification I have taken so far. I passed with 66.2%, just above…