JAJuan Andrés Lópezinmetadriven.hashnode.dev·3d ago · 11 min readGoodbye Button Clutter: Building Contextual Action Menus with Oracle APEX 26Introduction Almost every business application includes pages where users need to perform multiple actions on their data. Think about an order management system. Users may need to approve orders, gene00
JAJuan Andrés Lópezinmetadriven.hashnode.dev·Jul 24 · 11 min readSQL Domains in Oracle DatabaseAfter working with a database for a few years, repetition starts to appear almost everywhere. The same status values are validated in several tables. Priority columns use slightly different definition00
JAJuan Andrés Lópezinmetadriven.hashnode.dev·Jul 16 · 12 min readSQL Assertions in Oracle Database 26ai: A Different Way to Enforce Data IntegrityIntroduction After many years working with Oracle Database, I still run into features that make me wonder how I missed them. That happened recently with SQL Assertions. While reviewing some of the new00
JAJuan Andrés Lópezinmetadriven.hashnode.dev·Jul 6 · 6 min readOne Database, Two Worlds: Getting Started with JSON Relational Duality Views in Oracle Database 26aiThe challenge is that modern applications don’t always think in terms of rows and joins. REST APIs, mobile apps, and JavaScript front ends usually expect JSON documents, not multiple result sets stitc00
JAJuan Andrés Lópezinmetadriven.hashnode.dev·Jun 29 · 5 min readOracle JSON Has Grown Up I still remember the first time I had to store JSON in Oracle Database. The solution worked, but it wasn't exactly pleasant. Everything went into a CLOB, every query required JSON_VALUE(), and updatin00
