Skip to Main Content

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!

How to extract some fields from a CLOB JSON field

Friends, I need some help, I'm making an extract of some data that is formatted in JSON, but I'm not able to return the information from within the ARRAY. Example file follows.

{
"data": {
"surveys": [
{
"uuid": "a7b4347a-c950-4458-6eb3-13352f50b0fc",
"name": "return 2023-04-17 14:19:14"
},
{
"uuid": "d674e6d6-7a61-4f79-5156-595a3dbe52af",
"name": "return 2023-05-08 09:43:20"
},
{
"uuid": "6b9c4b2e-4798-42e3-4f92-ce50af16534e",
"name": "1001"
},
{
"uuid": "79f9c654-d210-4260-7ca5-39c4140e1258",
"name": "return 2023/0001"
}
]
},
"success": 1,
"message": ""
}

Comments
Post Details
Added on May 16 2023
2 comments
1,938 views