SQL> create table xmldata(
2 xmldoc clob )
3 /
Table created.
SQL>
SQL> insert into xmldata values
2 ( to_clob( '
3
4
5 7
6 S
7 CLERK
8 7
9 12/17/2008 0:0:0
10 999
11 20
12
13
14 /
1 row created.
SQL>
SQL> select * from xmldata;
XMLDOC
--------------------------------------------------------------------------------
9999
S
CLERK
1111
12/17/2008 0:0:0
111
20
1 row selected.
SQL>
SQL> drop table xmldata;
Table dropped.
SQL>
SQL> --