Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

oracle 19c Json nested select query to parse it

srinivasa ramagiriMar 13 2025 — edited Mar 13 2025

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
This post has been answered by Solomon Yakobson on Mar 13 2025
Jump to Answer

Comments

Post Details

Added on Mar 13 2025
4 comments
123 views