A better way to convert HTML entities to special characters in a BI report.

Summary:

A better way to convert HTML entities to special characters in a BI report.

Content (required):

I'm looking for a way to convert HTML entities to special characters listed below from a BI report without using functions such as REPLACE() and TRANSLATE().

Those special characters are mainly stored in "HRG_GOALS"."LONG_DESCRIPTION" and "HRG_GOALS"."SUCCESS_CRITERIA_TEXT" 

and it looks like it takes too much time to replace or translate each entity with REPLACE() and TRANSLATE().

HTML entities / Special Characters

  / " "

→ / "→"

⇒ / "⇒"

× / "×"

± / "±"

“ / "“"

” / "”"

It seems all the HTML tags can be replaced using "REGEXP_REPLACE(hg.LONG_DESCRIPTION,'<[^>]*>')",