Mega Code Archive
Reference one element
<![CDATA[
SQL> create table myTable of xmltype;
Table created.
SQL>
SQL> insert into myTable values(XMLTYPE('
2 <customer>
3 <name>AAA</name>
4 <telephone>123 555-1234</telephone>
5 </customer>'))
6 /
1 row created.
SQL>
SQL> select * from myTable;
SYS_NC_ROWINFO$
------------------------------------------------------
<customer>
<name>AAA</name>
<telephone>123 555-1234</telephone>
</cu
1 row selected.
SQL>
SQL> update myTable c
2 set value(c) = updateXML(value(c), '/customer/telephone/text()','888 555-1234')
3 where existsnode(value(c),'/customer/name = "Chris Smith"') = 1
4 /
0 rows updated.
SQL>
SQL> drop table myTable;
Table dropped.
]]>