oracle中blob类型的字段如何实现模糊查询？

Question

Answer 1

select * from gc_exp_operateinfo t where dbms_lob.instr(t.expxml,utl_raw.cast_to_raw('协同码'),1,1)<>0;