Home » SQL & PL/SQL » SQL & PL/SQL » reading all values of json table (Oracle 19c)
reading all values of json table [message #687691] Wed, 10 May 2023 01:54 Go to next message
sss111ind
Messages: 634
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]

Report message to a moderator

Re: reading all values of json table [message #687693 is a reply to message #687691] Wed, 10 May 2023 05:57 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
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.
Re: reading all values of json table [message #687695 is a reply to message #687693] Wed, 10 May 2023 09:52 Go to previous message
Barbara Boehmer
Messages: 9077
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: Fri Mar 29 10:16:08 CDT 2024