RE: How to extract Values from the complex XML (unstructured) document

Hi Gurus,

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

<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>5538</ItemID>
    <PriceListID>1103</PriceListID>
    <FeeName>Dairy Goat</FeeName>
    <Fee>25</Fee>
    <DepartmentNumber>H</DepartmentNumber>
    <BreedID>4380</BreedID>
    <BreedName>Saanen</BreedName>
    <ClassNumber>0</ClassNumber>
    <AnimalID>114506</AnimalID>
    <AnimalName /> 
  </Animals>
  <Others>
    <PriceListID>1103</PriceListID>
    <ItemID>742</ItemID>
    <FeeType>OTHER</FeeType>
    <FeeName>Carnival Tickets</FeeName>
    <Fee>50</Fee>
    <Quantity>2</Quantity>
  </Others>
  <Others>
    <PriceListID>1103</PriceListID>
    <ItemID>2784</ItemID>