select * from table t
where
t.id like {param} ||
页面上若是给 param 输入值为: % 或是 _ 则被orcale解析为通配符了
如何避免呢?
select * from table t
where
t.id like REPLACE(REPLACE(REPLACE({param}, '\', '\\'), '%', '\%'), '_', '\_') || '%' ESCAPE '\'
select * from table t
where
t.id like {param} ||
页面上若是给 param 输入值为: % 或是 _ 则被orcale解析为通配符了
如何避免呢?
select * from table t
where
t.id like REPLACE(REPLACE(REPLACE({param}, '\', '\\'), '%', '\%'), '_', '\_') || '%' ESCAPE '\'