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 case-insensitive in CLOB

283150Aug 21 2002

I have a problem in searching keyword in CLOB field. I need to search as case-insensitive. I tried to use "DBMS_LOB.INSTR" function but it supported only case-sensitive. Does anyone have any idea?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 20 2002

Added on Aug 21 2002

1 comment

956 views