i have varchar2 field with values like this: **"abc&#193&#158ef"** and I need to replace all of the **UTF substrings** (e.g. #&123) with its corresponding characters in **DB encoding (cp-1250)**.

Any suggestion?