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!

Extract Key-Value pair from a string

A13garpSep 28 2021

We have the some strings like this:
ID_PERSON:81049;ID:0100123-123456;NOME:XX YY ZZ;COD_PORT:0100116;
We are looking for a SQL query to produce the following result set:
KEY VALUE
ID_PERSON 81049
ID 0100123-123456
NOME XX YY ZZ
COD_PORT 0100116

Comments
Post Details
Added on Sep 28 2021
5 comments
3,701 views