blob数据不能用like进行模糊查询,否则会报错
要用一下语句:
dbms_lob.instr(要模糊查询的字段,utl_raw.cast_to_raw(模糊查询的关键字),1,1)<>0
转自:https://blog.youkuaiyun.com/dlx804332206/article/details/38535529
blob数据不能用like进行模糊查询,否则会报错
要用一下语句:
dbms_lob.instr(要模糊查询的字段,utl_raw.cast_to_raw(模糊查询的关键字),1,1)<>0
转自:https://blog.youkuaiyun.com/dlx804332206/article/details/38535529