JAJuan Andrés Lópezinmetadriven.hashnode.dev·3d ago · 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
JAJuan Andrés Lópezinmetadriven.hashnode.dev·Jun 17 · 4 min readOne of the Most Useful Oracle 23ai Features I Didn't Know I Needed: RETURNING OLD and NEWSometimes the features that make the biggest difference are not the flashy ones. They don't involve AI. They don't require machine learning models. And they probably won't appear on conference keynote00
JAJuan Andrés Lópezinmetadriven.hashnode.dev·Jun 9 · 7 min readJavaScript Inside Oracle Database?When I first heard that Oracle Database could execute JavaScript directly inside the database, my reaction was probably the same as many developers: Wait... why would I want JavaScript running in my 00
