I have this input: abc,abc,123,000,123,000
And I need to remove duplicates words.
The output must be: abc,123,000
I'm using this regexp: \\b(\\w+)\\b\\s*,\\s*(?=.*\\1) but it doesn't work. I'm testing in this page were works: https://regex101.com/r/sS2dM8/24
I'm using select regexp('abc,abc,123,000,123,000','\\b(\\w+)\\b\\s*,\\s*(?=.*\\1)','') from dual();
but the output is abc,abc,123,000,123,000
can you help?