SQL & PL/SQL

Hi,

I've a table with CLOB columns. Though the data in CLOB has multiple rows, I'm getting only one row as output when selecting from sqlplus / my front end (ASP).

How do I get the data stored in CLOB as is... without replacing the CHR(10).

I've a table tblx as below
tblx(col1 varchar2(20),
col2 clob,
col3 clob,
col4 varchar2(20),
col5 date);

the data in col2 is something like this.

COL2
1. row1Line1
2. row1Line2
3. row1Line3
4. row1Line4

This is only one row in the CLOB column, with 4 lines.

I'm using the below statement to select from tblx.

select col2 from tblx;

I get the output as below

COL2

1. rowLine1 2. row1Line2 3. row1Line3 4. row1Line4.

How can I get the output as

COL2
1. row1Line1
2. row1Line2
3. row1Line3
4. row1Line4

Please let me know.

Thanks in advance.

Regards,
Jai.