Programmatic Access to JSON in Oracle Database 12.2

By Yuli Vasiliev Starting with Oracle Database 12c Release 2, PL/SQL supports JSON, thus enabling programmatic access to JSON data within the database. In particular, SQL/JSON functions and conditions, such as json_object, json_query, and json_exists have been included to PL/SQL as built-in functions. Also, you can take advantage of the PL/SQL object types for JSON, such as JSON_ELEMENT_T, JSON_OBJECT_T, and…