# Querying Json\_Object\_t using dot notation in Oracle 19c

**URL:** <https://forums.percona.com/t/querying-json-object-t-using-dot-notation-in-oracle-19c/31760>\
**Category:** MySQL & MariaDB\
**Tags:** mysql\
**Created:** [July 23, 2024, 4:21am UTC](https://forums.percona.com/t/querying-json-object-t-using-dot-notation-in-oracle-19c/31760 "2024-07-23T04:21:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vivansai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vivansai/32/16940_2.png) [@vivansai](https://forums.percona.com/u/vivansai)\
**Post date:** [July 23, 2024, 4:21am UTC](https://forums.percona.com/t/querying-json-object-t-using-dot-notation-in-oracle-19c/31760/1 "2024-07-23T04:21:39Z")

</div>

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);

```auto
Json:
{"Key1":{"Key2":{"Key3": "Val3"}}}

```

I am able to access particular key-value using below code

```auto
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

```auto
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?

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [July 23, 2024, 2:43pm UTC](https://forums.percona.com/t/querying-json-object-t-using-dot-notation-in-oracle-19c/31760/2 "2024-07-23T14:43:45Z")

</div>

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.