Hi Dear Friends,
Hope you are doing good .
I am stuck in a situation where in I need to extract the values for keys from JSON and it has to be done in Oracle 11g, SQL only and no PL/SQL .
Below is the JSON ..
I need to get the values for PartyName, PartyTypeCode etc from below JSON in Oracle SQL,11g .
{
"relationships": {
"keyIndicator": false,
"keyContIndicator": false,
"relatedParties": [{
"keyPosition": "Position2",
"PartyName": "KEY CONTROLLER CONNECTED KEY CONT CONNECTED",
"RelationshipCode": "3",
"IndetificationNumber": null,
"PartyTypeCode": "000001",
"individualParty": {
"individualDetails": {
"residentialAddress": {
},
"CitizenshipCodes": ["AU"]
}
},
"orgConnectedParty": {
"registeredAddress": {
}
},
"ExistingCustomerIndicator": false
},
{
"PartyName": "TEST",
"RelationshipCode": "B",
"IndetificationNumber": null,
"PartyTypeCode": "000001",
"keyPosition": "Position2",
"individualParty": {
"individualDetails": {
"residentialAddress": {
},
"CitizenshipCodes": ["MO"]
}
},
"organisationParty": {
"registeredAddress": {
}
},
"ExistingCustomerIndicator": false
},
],
"partyRelationships": []
}
}
Thanks very much in Advance ..