Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

JSON SQL query

SravpremMay 20 2024 — edited May 20 2024

Hi

we are getting special character " \ in JSON data. example second line in below JSON doc. could you help me in sql query to get output like below

ABC . type . title . special

STUDY S_STUDY Covered Farm serg8bf31

{"ABC": "STUDY",
"fieldsData": "{\"type\": \"S_STUDY\", \"title\": \"Covered Farm \", \"endDate\": \"11/08/2021\", \"startDate\": \"11/08/2024\"}",
"special": "serg8bf31"
}

Comments
Post Details
Added on May 20 2024
2 comments
113 views