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!
Hello,
What is the equivalent of the below if the column type is CLOB
where lower(prod_desc) like lower('test%')
When I tried with
dbms_lob.instr(prod_desc,'test')>1
the result set is incorrect.
Appreciate any insight.