Querying Json_Object_t using dot notation in Oracle 19c

MySQL & MariaDB
1

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?

2

Hello @vivansai,
I doubt you will find much help regarding Oracle 19c on these forums. Percona is an Open Source Database performance company, and Oracle 19c isn’t open source (Maybe there is confusion with Oracle MySQL which is open-source). You might have better luck on stack exchange or other Oracle-focused forums.