Oracle blob like 查询

select *
  from 表名
 where dbms_lob.instr(列名,utl_raw.cast_to_raw('xx'),1,1) <> 0;