Store an XMLType type data in clob
SQL> CREATE TABLE myTable 2 (myID NUMBER PRIMARY KEY, 3 myValue XMLTYPE ) 4 XMLTYPE myValue STORE AS CLOB 5 / Table created. SQL> SQL> drop table myTable; Table dropped. SQL> SQL>