Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI: Replace Line Feed characters from CLOB column
Harshal Sarode-Oracle
Rank 1 - Community Starter
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?
0