How to find unique words in a string?
54373Feb 9 2008 — edited Feb 9 2008Is there an Oralce Routine in RDMBS 10.2 which searches in a string for the unique words and return them.
For example:
Select <function unique words> ('aa bb cc cc bb aa ee f ggg f h')
From dual;
Returns the following:
aa bb cc ee f ggg h
Thanks in advance
Auke Quist