Update (i.e. replace) the entire XMLType column with new content
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 = xmltype('<?xml version="1.0" standalone="yes"?> 3 <message type="1"> 4 <greeting>Hi</greeting> 5 <body>body!</body> 6 </message> 7 '); 0 rows updated. SQL> SQL> SQL> drop table myTable; Table dropped.