AVAndré van der Putinavanderput.hashnode.dev·Jul 10 · 5 min readAdding a dynamic list to a static Navigation Bar In one of my APEX applications, I have a table containing a number of website URLs. I want to make it available to the users from anywhere within the application. A logical solution would be to have a00
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
