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!

Counting a particular word in a string

Aparna16Jul 17 2012 — edited Jul 17 2012
Hi All,

Have a query to find the occurence of a particular word in a string using a query.

ex: str := 'a,b,a,c,d'

search_str := 'a'

=> need to get the number of times 'a' is getting repeated in the string str.


output: 2
----------

Hoping for the best support as always.

Edited by: Aparna16 on Jul 17, 2012 5:55 AM

Edited by: Aparna16 on Jul 17, 2012 5:56 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2012
Added on Jul 17 2012
9 comments
1,073 views