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> 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>