Skip to Main Content

DevOps, CI/CD and Automation

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!

I have a CLOB field with XML data and we need to convert the XML to columns with value concatenation

user8861986Mar 14 2019 — edited Mar 19 2019

Hi there,

I have an XML with data as below:

<row>

<c1>Name1></c1>

<c2>Name2</c2>

<c6>Addressline</c6>

<c6 m=1 s=2>Addressline 2 </c6>

<c6 m=1 s=1>Addressline 3 </c6>

<c6 m=2 s=1>Addressline 4</c6>

<c6 m=2 s=2>Addressline 5</c6>

<c6 m=2 s=3>Addressline 6</c6>

</row>.

I require the following output, but unfortuantely I could not find any help anywhere.

Fld 1        fld2        fld3

Name1    Name2  Addressline$Addressline 2$Addressline 3£Addressline 4$Addressline 5$Addressline 6

Means the values in "m" should be concatenated with $ and both "m" should be seprated with £

Thanks

Regards,

Wasif Hassan

This post has been answered by cormaco on Mar 15 2019
Jump to Answer

Comments

Post Details

Added on Mar 14 2019
5 comments
942 views