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,
3 'message/greeting/text()','test',
4 'message/greeting/body/text()','test again'
5 )
6 where id = 1;
0 rows updated.
SQL> drop table myTable;
Table dropped.
|