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!

How to optimize SQL using function 'instr' ?

248970Apr 1 2002
select textID from Texts
where instr(textContent, :strSearch);

There is a table 'texts', and primary key on column 'textID'.
I want to get those rows which column 'textContent' contains string :strSearch. This must be inefficient, but how can I complete it more efficient?

Thanks for help in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2002
Added on Apr 1 2002
2 comments
426 views