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!

Find string matches in CLOB

754749Nov 24 2010 — edited Nov 24 2010

I'm using: Oracle Database 10g Enterprise Edition.

I'm trying to count the amount of string occurrences a bind variable (some text phrase) shows up in a CLOB field and order by the # of matches. I have no idea where to being.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2010

Added on Nov 24 2010

5 comments

4,215 views