Forum Stats

  • 3,838,561 Users
  • 2,262,383 Discussions
  • 7,900,687 Comments

Discussions

Nested Dynamic JSON in PL/SQL

Rithu Raj
Rithu Raj Member Posts: 42 Blue Ribbon
edited Jul 25, 2022 11:24AM in SQL & PL/SQL

Hi Team,

I have a the following Json in one of the blob column of my table and would like to parse and source into table.

Sample Json: (It can be dynamic and nodes can be added at any parent)

{

 "SampleDescription": " sample description Sample. ",

 "SampleType": "Sample",

 "SampleStrm": "Test",

 "SampleMat": {

  "Child (s)": {

   "Info": 3,

   "Context": 1

  },

"Node (s)": {

   "Detail": 3,

   "Complex": 1

  }

 },

 "Sample Voltage": [

  "1000 MW/min (s)",

  "3000 MW/min (s)"

 ]

}

Now I have to parse them and store them in the below format

Can someone please assist?

Tagged:

Best Answer

Answers