XMLTYPE in Oracle9i/ XMLs with name-value pairs

Hi,

I have created the following table:

CREATE TABLE Test_XML (
XMLTypeID NUMBER(10),
DetailsXML XMLTYPE)
XMLTYPE DetailsXML STORE AS OBJECT RELATIONAL;

and have stored the following XML for XMLTypeID=1 in the column DetailsXML

<?xml version="1.0" encoding="ISO-8859-15"?>
<ArticleDetails>
<Technical Name="Name1" Value="Test"/>
<Technical Name="Name2" Value="Y"/>
<Technical Name="Name3" Value="Y"/>
</ArticleDetails>

1.) What's the easiest way to select the Value for Name="Name1"? 2.) How can I update Value for Name="Name1" in this XML?

Cheers
Juergen Received on Tue May 04 2004 - 10:38:47 CDT