Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> XMLTYPE in Oracle9i/ XMLs with name-value pairs

XMLTYPE in Oracle9i/ XMLs with name-value pairs

From: Juergen <juergen.gerlinger_at_web.de>
Date: 4 May 2004 08:38:47 -0700
Message-ID: <dc56b85a.0405040738.5d71748c@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US