Extracting XML attributes
Hi,
I insert XML document into MySQL table in varchar field. Following is the example of XML.
<PurchaseOrder>
<Reference>AMCEWEN-20030109123336271PDT</Reference>
<Actions/>
<Reject/>
<Requestor>Allan D. McEwen</Requestor>
<User>AMCEWEN</User>
<CostCenter>S30</CostCenter>
<ShippingInstructions/>
<SpecialInstructions>Expidite</SpecialInstructions>
<LineItems>
<LineItem ItemNumber="1">
<Description>Traffic</Description>
<Part Id="696303038591" UnitPrice="39.95" Quantity="2"/>
</LineItem>
</LineItems>
</PurchaseOrder>
I want to extract <LineItems> attributes. Can any one help me in this regards, how can I extract <LineItems> attributes with the use of Select statement.
Subject
Written By
Posted
Extracting XML attributes
August 07, 2006 11:40PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.