Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find unique words in a string?

54373Feb 9 2008 — edited Feb 9 2008
Is 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2008
Added on Feb 9 2008
2 comments
546 views