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!

REGEXP Key-Value Pairs parsing using PL/SQL

jhasanoffJun 6 2016 — edited Jun 6 2016

Hi all,

I have some string in below format as input value.

{ account_type=0 account_unit=0 direction=subnet charged=40002 destination=76 end_amount=9859937 expire_time=1496323865000  item=1 original_other_party=994702011342 other_party=994702011342 request_num=0 request_type=3 rounded=1 service_id=10004 session_id=10.13.44.74;341;348042993 start_amount=9899939 start_time=1464932308000 subscriber_id=180 subscription_id=1162 transaction_type=3 update_time=1464932308000 service=994700070000 }

I need to parse both keys and values separately using plsql and regular expressions.

Example:

keys:account_type,account_unit,direction,charged,destination.....

values: 0,0,subnet ,40002,76.....

Thanks in advance.

This post has been answered by alvinder on Jun 6 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2016
Added on Jun 6 2016
15 comments
2,656 views