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!
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