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