Oracle PL/SQL/XML/XML Save

Use to_clob to save xml string to a clob type column

   <source lang="sql">

SQL> create table xmldata(

 2      xmldoc clob )
 3    /

Table created. SQL> SQL> insert into xmldata values

 2    ( to_clob( "<?xml version="1.0"?>
 3    <ROWSET>
 4       <ROW num="1">
 5          <EMPNO>7</EMPNO>
 6          <ENAME>S</ENAME>
 7          <JOB>CLERK</JOB>
 8          <MGR>7</MGR>
 9          <HIREDATE>12/17/2008 0:0:0</HIREDATE>
10          <SAL>999</SAL>
11          <DEPTNO>20</DEPTNO>
12       </ROW>
13    </ROWSET>" ) )
14    /

1 row created. SQL> SQL> select * from xmldata; XMLDOC

---

<?xml version="1.0"?>

 <ROWSET>
    <ROW num="1">
       <EMPNO>9999</EMPNO>
       <ENAME>S</ENAME>
       <JOB>CLERK</JOB>
       <MGR>1111</MGR>
       <HIREDATE>12/17/2008 0:0:0</HIREDATE>
       <SAL>111</SAL>
       <DEPTNO>20</DEPTNO>
    </ROW>
 </ROWSET>

1 row selected. SQL> SQL> drop table xmldata; Table dropped. SQL> SQL> --

</source>