I have a case where Json document is passed as CLOB input to a stored procedure.
I am converting it into Json Object as below
l_js_obj := JSON_OBJECT_T(p_js_clob_i);
Json:
{"Key1":{"Key2":{"Key3": "Val3"}}}
I am able to access particular key-value using below code
l_js_obj.get _object('key1').get_object('key2').get_string('key3');
By storing this CLOB into a column in a table, I am able to access the json using dot notation
Select t.column.key1.key2.key3 From t;
My question is, is it possible to access JSON_OBJECT_T using dot notation in Oracle 19?