Rakesh Singh, November 03, 2017 - 7:27 am UTC
Thanks, i got the answer what i was looking for.
Translate function
Rajeshwaran Jeyabal, November 03, 2017 - 12:35 pm UTC
Translate would be other option.
demo@ORA11G> select translate('ascjhsdndfdaja','abcdefghijklmnopqrstuvwxyz','a') from dual
2 /
TRA
---
aaa
demo@ORA11G>
November 03, 2017 - 1:36 pm UTC
Provided you only have (lowercase) letters in the input ;)