Replace characters using a table including two space substitutions?

Viewed 20

Referring to this question & answer: PL/SQL Replacing characters in a string using another table

Is there a way to include in such substitutions equivalences like:

  • "ß" to "ss"
  • "å" to "aa"
  • "ñ" to "nn"

Without needing to do so one by one?

I understand the TRANSLATE function work by concatenating a list of "source" and "objective" sets of characters, but sometimes the equivalences might require changes like the ones above.

0 Answers
Related