René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Inserting an XML document into XML DB

First, a table is needed to store the document.
create table xml_insert (
  id  number primary key,
  doc XMLType
);
insert into falls values (1, sys.XMLType.CreateXML(
'<?xml version="1.0"?>
<hello>
  bla
</hello>'));