OraFAQ Forum: SQL & PL/SQL » reading all values of json table

Home » SQL & PL/SQL » SQL & PL/SQL » reading all values of json table (Oracle 19c)

Wed, 10 May 2023 01:54

sss111ind
Messages: 636
Registered: April 2012
Location: India

Senior Member

Hi All,

How to read json values of nested element in Oracle 19c.

[Updated on: Wed, 10 May 2023 01:59]

Wed, 10 May 2023 05:57

Solomon Yakobson
Messages: 3305
Registered: January 2010
Location: Connecticut, USA

Senior Member

Use JSON_TABLE or JSON_QUERY or JSON_VALUE. There are plenty of examples in Oracle docs.

SY.

Wed, 10 May 2023 09:52

Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA

Senior Member

Here is the best json_table documentation link that I could find for your version. If that doesn't solve your problem, then please post your data and your desired result and perhaps we can help figure it out.

https://docs.oracle.com/en/database/oracle/oracle-database/19/adjsn/function-JSON_TABLE.html#GUID-0172660F-CE29-4765-BF2C-C405BDE8369 A

Previous Topic:	elapsed time for a id
Next Topic:	How to get count of records that do not have more than 1 specific value in 1 column

Goto Forum:

]

Current Time: Tue Sep 02 19:18:20 CDT 2025