How to search a string in clob field?

[julian]

Simple:

Assume the table T1 has the clob column called C1 and we want to search for the string 'shailendra'.

select * from T1 where dbms_lob.instr(C1,'shailendra')>0;