Update (i.e. replace) the entire XMLType column with new content : UPDATEXML « XML « Oracle PL/SQL Tutorial

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.

33.8.UPDATEXML
	33.8.1.	UPDATEXML function supports multiple elements
	33.8.2.	Update (i.e. replace) the entire XMLType column with new content
	33.8.3.	Update xmltype type column
	33.8.4.	Use UPDATEXML function to update a portion of the doc
	33.8.5.	Use the UPDATEXML function to change element value