About the best you can do for CLOB fields is to use the DBMS_LOB supplied PL/SQL package. With the DBMS_LOB.INSTR function, you should be able to create some limited searching on CLOB fields.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.