my table test_table and it has column test_js column and example of json oracle 19c below. please write oracle 19c sql
pid is nothing object access key.
{
"testByEarnings": true,
"testAllocationOverrideMap": {
"14735664_1": [
{
"costOid": "default",
"allocationOverride": 50
},
{
"costOid": "37497194_1",
"allocationOverride": 50
}
],
"33070369_1": [
{
"costOid": "default",
"allocationOverride": 50
},
{
"costOid": "37497194_1",
"allocationOverride": 50
}
],
"36601979_1": [
{
"costOid": "default",
"allocationOverride": 50
},
{
"costOid": "37497194_1",
"allocationOverride": 50
}
]
}
}
I need to print like this using oracle 19c sql.
pid costOid allocationOverride
14735664_1 default 50
14735664_1 37497194_1 50
33070369_1 default 50
33070369_1 37497194_1 50