12.2’s JSON_OBJECT to Construct JSON in the Database Now with new release of Oracle Database (12.2), you can construct JSON data in the database from non-JSON data, using new SQL/JSON functions, such as: JSON_OBJECT, JSON_ARRAY, JSON_ARRAYAGG, and JSON_OBJECTAGG. This article takes a look at JSON_OBJECT, which you can use to generate JSON objects from name–value pairs. The examples in this…