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!

How to remove duplicate values from XMLTYPE?

User_2K4XPMar 9 2022

I have the following XMLTYPE in which section between lines 7 to 20 is exactly same as section between lines 21 to 34.
How do I pick up only the distinct section.
Basically I need the TRIndicator and TRName, but on extraction it gives me a YESYES in TRIndicator and XYZXYZ in TRName.
Please advise
We are using Oracle Database 19c .
Thanks!

Added on Mar 9 2022

#oracle-developer-communities, #pl-sql-xml-programming, #xml

3 comments

1,111 views