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!

Parse JSON string in SQL

msbJun 23 2022 — edited Jun 23 2022

Hello All,
Oracle version is 19C. I have a JSON string like below.
{“sourceSystem": “WA” , "type":"ID”, "region”:”WASHINGTON”, "value":"2024559”, "formatted": "RGN: ID: WAS: 2024559”}
The SQL parse the string and extract the string from formatted like below
Region ID
WAS 2024559

Added on Jun 23 2022

3 comments

257 views