Remove duplicates in a string
Hi all,
I have requirement of removing duplicates from a string.
Imagine, i have a sting 'abcd abde befg' (for the sake of readability i did put space),
the output of the query should print 'abcdefg'
Query should be generic to remove all duplicates from the string.
Not a restricted query for this particular example string.
I have tried to formulate a query with REGEXP_REPLACE but not successful.
Any help would be greatly appreciated.
Regards,
Srini