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.