Use to_clob to save xml string to a clob type column : XML Save « XML « Oracle PL / SQL






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

 








Related examples in the same category