PGPhil Grinhaminphilgrinham.hashnode.dev·Jun 30 · 9 min readMaterialized Views: The Sweet SpotThe Inspiration I recently read an article from the always excellent Connor McDonald that I highly recommend where he provided a solution on how to maintain a materialized view that needs to be "up to00
JAJuan Andrés Lópezinmetadriven.hashnode.dev·May 29 · 6 min readOracle finally did it: BOOLEAN is now supported directly in SQL. For years, one of the most curious limitations in Oracle Database was the absence of a real BOOLEAN data type in SQL. Yes — Oracle supported BOOLEAN in PL/SQL for decades. But not in SQL itself. That 00
NANaif Amoodiinnaifamoodi.hashnode.dev·Apr 23 · 2 min readWorking Around an Old Oracle DatabaseWe still work with a client whose day-to-day operation depends heavily on an old Oracle database, so a lot of our integration work ends up being shaped by the quirks of that database. One thing I lear20
BIBenjamin Intsifulinbintsiful.hashnode.dev·Mar 19 · 5 min readStop Hacking Data Integrity: Moving from Trigger Gymnastics to 26ai AssertionsFor a long time, compound triggers have been the unsung heroes of the Oracle world. They weren't always our first choice because of their complexity, but they were the reliable "Swiss Army knives" we 00
BIBenjamin Intsifulinbintsiful.hashnode.dev·Mar 17 · 7 min readWhat a Room Booking Question on Oracle Forums Taught Me About Data Modeling in Oracle APEXI was recently poking around the Oracle developer community—specifically the Oracle SQL&PL/SQL Forums, which is still a goldmine if you can ignore the occasional grumpy old-timer—and found a guy strug00
BIBenjamin Intsifulinbintsiful.hashnode.dev·Feb 28 · 5 min readWhy COUNT(*) Is a Performance TrapJust like most teams that practice Agile methodologies some years ago; It was 4:15 PM. The sprint demo was live. The dashboard looked great until someone clicked the "Customer Health" tab. Then? Silen00
VJVinny Jiménezininsightsapex.vinnyum.tech·Feb 19 · 7 min readCaching Strategies: APEX & Database CacheThe Fastest Query is the One You Never Run 🇪🇸 Leer en Español There is a common misconception in database development: "If it's slow, just add an index." While indexing is critical, it solves a stor00
RGRafal Grzegorczykinrafal.hashnode.dev·Jan 24 · 5 min readLOGGER - a quick start to debug, track errors or calculate code timings in PL/SQLWhat is LOGGER? It’s a PL/SQL logging and debugging framework. It’s super simple to install and use. Yes, you can also use it in PL/SQL within Oracle APEX or in any other application that uses Oracle Database. What are the benefits of using it for YO...00
VJVinny Jiménezininsightsapex.vinnyum.tech·Jan 20 · 5 min readPL/SQL Best Practices for Backends: Architecting for Success🇪🇸 Leer en Español Stop Building Page-Bound Monoliths 💡 "Secure by default does not mean secure by design." In the Oracle APEX ecosystem, this reality is often ignored in favor of 'low-code' speed00
VJVinny Jiménezininsightsapex.vinnyum.tech·Dec 16, 2025 · 6 min readREST API Integration in Oracle APEX🇪🇸 Leer en Español 1. Introduction: The API-First World Modern applications rarely live in isolation. They exchange data with CRMs, ERPs, payment gateways, and internal microservices. For Oracle APE00
