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!