I mean, you can use only stored function for search operation in CLOB fields.
In this function you can execute any funttions/procidure from DBMS_LOB package.
May be you may create FUNCTION-BASED INDEX for better perfomance of search operation on CLOB fields.




Reply With Quote