Oracle support XPath predicate expressions : XPath « XML « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. XML
3. XPath

SQL> CREATE TABLE myTable
  2  (id  NUMBER PRIMARY KEY
  3  ,doc XMLType NOT NULL)
  4  XMLTYPE doc STORE AS CLOB
  5  /

Table created.

SQL>
SQL>
SQL> 
SQL> update myTable
  2  set doc = updateXml( doc,'message[greeting="Hi"]/body/text()', 'test again')
  3  /

0 rows updated.

SQL>
SQL> drop table myTable;

Table dropped.

SQL>