hi,

I have to make a query which has in the where clause a condition which is that a certain string is included in the clob field.
Is there any function which does this or no?

select *
from t1
where t1.clobfield like '%string_var%';

thanks