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!

Parse the column value

msbMay 16 2024 — edited May 16 2024

Hello Everyone,

Database version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

I have a column called “transaction details” and the values are like below

{"PNUM":"1111","fill":"t","mail":"t"},{"PNUM":"2222","fill":"t","mail":"t"},{"PNUM":"3333","fill":"t","mail":"t"},{"PNUM":"4444","fill":"t","mail":"t"},{"PNUM":"5555","fill":"t","mail":"t"},{"PNUM":"6666","fill":"t","mail":"t"},{"PNUM":"7777","fill":"t","mail":"t"},{"PNUM":"8888","fill":"t","mail":"t"}

Any way to parse the above value and display like below.

Comments
Post Details
Added on May 16 2024
4 comments
132 views