'how to convert json to row and column format using oracle
{ "Message ": [ { "PACK_NO": "219069571", "COMPONENT_ITEM": [ { "ITEM": "308187417", "PACK_QTY": 2 } ] }, { "PACK_NO": "219069572", "COMPONENT_ITEM": [ { "ITEM": "308187419", "PACK_QTY": 2 } ] }, { "PACK_NO": "219178060", "COMPONENT_ITEM": [ { "ITEM": "308235779", "PACK_QTY": 2 } ] }, { "PACK_NO": "219178061", "COMPONENT_ITEM": [ { "ITEM": "308235775", "PACK_QTY": 1 }, { "ITEM": "308235777", "PACK_QTY": 1 }, { "ITEM": "308235778", "PACK_QTY": 2 }, { "ITEM": "308235779", "PACK_QTY": 2 }, { "ITEM": "308235780", "PACK_QTY": 2 }, { "ITEM": "308235781", "PACK_QTY": 2 } ] } ] }'
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|