Read JSON using API in Oracle Database

Hi All,

Do we have any API in oracle database to read the below JSON format and extract the value. Like in this case, I need to extract the 'VALUE' field based on the 'CHARC' field in the JSON data

{

 "config": [

  {

   "CHARC": "TEST1", 

   "VALUE": "M"

  },

  {

   "CHARC": "TEST2", 

   "VALUE": "RH" 

  },

  {

   "CHARC": "TEST3", 

   "VALUE": "5"

  }

 ]

}