Question

如何对ORACLE里的CLOB字段进行模糊查询

Answer 1

select *
from table t
where dbms_lob.substr(t.字段) like '%你要查询的东西%';