SELECT
	* 
FROM
	GSMS_PHRASE 
WHERE
	utl_raw.cast_to_varchar2 (
	DBMS_LOB.SUBSTR(字段名, 4000, 1 )) LIKE '%1223%'

queryds实现l对blob模糊查询

BooleanBuilder builder.and(dmBlob(p.content).likeIgnoreCase("%" + content + "%"));
public StringExpression dmBlob(Object arg){
         StringExpression contentAsString = Expressions.stringTemplate(
                "utl_raw.cast_to_varchar2(DBMS_LOB.SUBSTR({0},4000,1))", arg
        );
         return  contentAsString;
 }