Skip to Main Content
Forums

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!

search on a clob column

Roy4321Aug 26 2011 — edited Aug 31 2011
Hi All,

We have a requirement to do "LIKE" search on a clob column. One of the pattern of search will be like 'Test1%Test2%Test3'.

Using "dbms_lob.instr". ( In String) will not work as Test2 should appear after test1 and test3 after test2..

Is there any workaround for this? Please suggest.

Thanks in advance

Roy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2011
Added on Aug 26 2011
6 comments
17,548 views