CLOB column contains line breaks in html. We tried following function which works only if CLOB column character length is less than 4000.
REPLACE(REPLACE(REPLACE(CAST("Performance Goals"."Success Criteria" AS VARCHAR2(4000)) ,'<br/>',''),'<p>',''),'</p>','')
Does OTBI support TRANSALTE or EVALUATE? if not, do we have any other means by which we can replace line breaks from CLOB column exceeding 4000 chars?
