SQL> create table MyTest(
2 ch clob
3 );
Table created.
SQL>
SQL> insert into myTest values('A simple line of text');
1 row created.
SQL> insert into myTest values('Line 1; \n line 2');
1 row created.
SQL>
SQL> select * from mytest;
CH
--------------------------------------------------------------------------------
A simple line of text
Line 1; \n line 2
SQL>
SQL>
SQL> drop table myTest;
Table dropped.