@avanderput

André van der Put

@avanderput

Oracle APEX developer

Joined April 2025

About

Nothing here yet.

Available for

Nothing here yet.

André van der Put's blogs

Put Postavanderput.hashnode.dev9 posts

Articles Threads Comments

Recently published

AVAndré van der Putavanderput.hashnode.dev

A single query to decompose JSON using the APEX_JSON package, part 1

Apr 17 · 7 min read · Sometimes 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 ca

Join discussion

AVAndré van der Putavanderput.hashnode.dev

Controlling access to ORDS RESTful Services

Apr 3 · 6 min read · In 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

Join discussion

AVAndré van der Putavanderput.hashnode.dev

Using Assertions to enforce Business Rules

Mar 13 · 6 min read · In 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 bet

Join discussion

AVAndré van der Putavanderput.hashnode.dev

The ORA-00604 error: one possible cause

Feb 27 · 2 min read · Recently I wanted to modify an existing view. I needed to add a few extra colums from another table. So the original view was something like create or replace view testview as select t1.id , t1.c

Join discussion

AVAndré van der Putavanderput.hashnode.dev

How to delete an Interactive Report subscription

Oct 8, 2025 · 3 min read · Recently one of our testers asked me to remove an Interactive Report subscription. He still received an email every week from an Interactive Report in one of our applications. But he didn’t know if it was the Development, Test or Acceptance environme...

Join discussion

André van der Put

About

Available for

André van der Put's blogs

Recently published

A single query to decompose JSON using the APEX_JSON package, part 1

Controlling access to ORDS RESTful Services

Using Assertions to enforce Business Rules

The ORA-00604 error: one possible cause

How to delete an Interactive Report subscription

Search Hashnode

André van der Put

About

Available for

André van der Put's blogs

Recently published

A single query to decompose JSON using the APEX_JSON package, part 1

Controlling access to ORDS RESTful Services

Using Assertions to enforce Business Rules

The ORA-00604 error: one possible cause

How to delete an Interactive Report subscription