RE: How to self-join/union the XMLTables and extract distinct records from XML document (unstructur

Hi XML Gurus,

I am new to XML queries. The data has been stored in the database as a CLOB.  I have the following XML file sample

<CustomerEntry xmlns="http://oracle.com/Entry.xsd">
  <Customers>
    <Type>EXHIBITOR</Type>
    <CustomerNumber>1158124</CustomerNumber>
    <CustomerID>240259</CustomerID>
    <AddressID>250420</AddressID>
  </Customers>
  <Customers>
    <Type>OWNER</Type>
    <CustomerNumber>1158124</CustomerNumber>
    <CustomerID>240259</CustomerID>
    <AddressID>250420</AddressID>
  </Customers>
  <Animals>
    <ItemID>1702</ItemID>
    <PriceListID>1103</PriceListID>
    <FeeName>Beef Cattle (Non Specialty)</FeeName>
    <Fee>30</Fee>
    <DepartmentNumber>A</DepartmentNumber>
    <BreedID>5002</BreedID>
    <BreedName>Brahman - Grey</BreedName>
    <ClassNumber>19</ClassNumber>
    <ClassName>Late Senior Yearling Heifers</ClassName>
    <AnimalID>113987</AnimalID>
    <AnimalName>JDH LADY TRUDY MANSO</AnimalName>
    <Gender>Female</Gender>
    <RegistryNumber>887181</RegistryNumber>