---blob模糊查询
select *
from user.table
where utl_raw.cast_to_varchar2(DBMS_LOB.SUBSTR(字段, 2000, 1)) like
'%123%';
Oracle Blob字段如何模糊查询
最新推荐文章于 2021-04-07 09:35:09 发布
---blob模糊查询
select *
from user.table
where utl_raw.cast_to_varchar2(DBMS_LOB.SUBSTR(字段, 2000, 1)) like
'%123%';