I have a requirement to display the text in HTML Output. In the item description I was encountering an issue with &, whenever this symbol is present the concurrent program is completing with Warning.
To overcome this issue, we need to change the & symbol with &
Solution:-
select regexp_replace(tc_description,'&', '\&'||'amp;') from xx_table;
The output of the query without replacing the description is:
Installation & Training (Small Library)
Now after changing the query, the output is
Installation & Training (Small Library).
For my requirement the above query has given the result.
No comments:
Post a Comment