Remove repeating letters
11gR2 DB
We have a string token with all small leters (Sample - abcdaeebfghiejklc)
Need to remove all the repeating letters in this tring. Output should be abcdefghijkl
I know how to do it by splitting the string into multiple rows, then use listagg to make it a string.
But can we do it use without using any kind of row generation. By regexp or something?