LinkedIn

My journey with JSON data in Oracle PL/SQL

Working with JSON data in Oracle PL/SQL has opened up new possibilities for handling complex data structures seamlessly. Here are a few insights from my journey: 🔹 What are JSON Procedures? JSON ...
GitHub

PLSQL-JSON: The JSON encode/decode library for PL/SQL

PL/SQL-JSON implements encoding and decoding JSON in a PL/SQL environment. Using the objects json_object and json_array allows to compose and parse JSON. A performance test is avilable in the ...
LinkedIn

How to manipulate JSON in PL/SQL with new object types

Manipulate #JSON in PL/SQL with the object types added in 12.2 JSON_ELEMENT_T JSON_SCALAR_T JSON_OBJECT_T JSON_ARRAY_T With functions to get, put, and remove you can fetch, add, and delete values from ...
GitHub

ob_json_pl_utils.h

static int get_json_object(sql::ObExecContext &ctx, ObJsonNode*& json_val); static int get_json_array(sql::ObExecContext &ctx, ObJsonNode*& json_val); static int get ...