Oracle PL/SQL/XML/XML Save

Use to_clob to save xml string to a clob type column

 
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> --