Hi,
I have a table called
document with two columns:
create table document (
title varchar2 not null,
description clob not null
);
+-----------+--------------------------------------------+
| TITLE | DESCRIPTION |
+-----------+--------------------------------------------+
| title 1 | <span><font face="Tahoma" size="1">title 1 |
| | description</font></span> |
+-----------+--------------------------------------------+
The question is since the description column contains html, when I try to retrieve the value using a reports region (using a SQL query), it doesn't display the actual formatting. Rather it displays this:
<span><font face="Tahoma" size="1">title 1 description</font></span>
I would like to display the formatting just by retrieving the html from the CLOB column. Any thoughts on how I can achieve that? Do I need to change it into a different region (such as PL/SQL or HTML)?