SQL> CREATE TABLE myTable
2 (id NUMBER PRIMARY KEY
3 ,doc XMLType NOT NULL)
4 XMLTYPE doc STORE AS CLOB
5 /
Table created.
SQL>
SQL>
SQL> update myTable
2 set doc = xmltype('
3
4 Hi
5 body!
6
7 ');
0 rows updated.
SQL>
SQL> drop table myTable;
Table dropped.