dbms_lob.instr

insert into tab select rowid,systimestamp from tab1 where dbms_lob.instr(tab1.description ,'Oracle9i' ,3)>0 

SQL> insert into clob values(1,'aa','oracle');

1 row created.

SQL> insert into clob values(2,'aa','oracle is good oracle');

1 row created.


SQL>  insert into clob values(3, 'bb','oracle is bad bad oracle oracle');


1 row created.


SQL> commit;

SQL> /


ROWID              SYSTIMESTAMP                                     ID NAME       SOURCE
------------------ ---------------------------------------- ---------- ---------- --------------------------------------------------------------------------------
AAACrfAAAAAAFPmAAC 09-MAY-13 05.45.22.248727 PM -04:00               3 bb         oracle is bad bad oracle oracle

SQL> l
  1*  select rowid , systimestamp,id,name ,source from clob where dbms_lob.instr(source,'oracle',1,3)>0