PL/SQL Code snippet: easy way to generate a JSON string object in SQL queries

Introduction When pushing the limits of Oracle APEX widgets to add custom functionality, you are limited to one column to pass values from the database to the JavaScript side. This one column is often not sufficient as you need to pass more than one ...