Handle html tags in a clob field in Oracle reports
edited Jul 4, 2022 12:41AM in GoldenGate, Streams and Distributed Database (MOSC) 7 commentsAnswered
Hi,
I have a requirement where i need to display the data inside a clob type field in a table.
The issue is the data inside the clob field is plain text but with HTML formatting. I.e. being preapplied with <B> , <P>,<U> and other tags .
When i simply put a query on the table like
Select Clob_data form Table1(Where clob_data is the column storing the data) then the oracle report output directly shows the output as
"
The company's net growth is <B> 6Million </B> . <P> This year's revenue is much better as compared to that of the last year.</P>
0