AVAndré van der Putinavanderput.hashnode.dev·May 17 · 4 min readAssertions versus constraintsIn a previous blog post I described the new Assertions feature of Oracle Database 26ai. This feature makes it possible to define constraints between different tables. I also gave two examples of busin00
AVAndré van der Putinavanderput.hashnode.dev·May 5 · 8 min readA single query to decompose JSON using the APEX_JSON package, part 2In my previous blog post, I described how to decompose a JSON document with a single query. I used the APEX_JSON package, and with that I could keep the code quite simple. One drawback, however, was t00
AVAndré van der Putinavanderput.hashnode.dev·Apr 17 · 7 min readA single query to decompose JSON using the APEX_JSON package, part 1Sometimes I want to examine in detail a JSON document that is stored in the database. I just want an overview of all the fields in the document, possibly with their values. The JSON document itself ca20
AVAndré van der Putinavanderput.hashnode.dev·Apr 3 · 6 min readControlling access to ORDS RESTful ServicesIn this blog post I will explain how access control in ORDS REST services can be configured. I will discuss both module protection and pattern protection, and explain in which situations these should 00
AVAndré van der Putinavanderput.hashnode.dev·Mar 13 · 6 min readUsing Assertions to enforce Business RulesIn Oracle, we have long been accustomed to defining constraints at the table level in the database. These are enforced for us by the database. Until recently, this was not possible for constraints bet00
