经测试oracle10g数据库中的特殊字符可经escape进行转义的只有_ 和 %
select * from ( select distinct daamunifor0_.ID as ID1_35_, daamunifor0_.CAPTION as CAPTION2_35_, daamunifor0_.CODE as CODE3_35_, daamunifor0_.CREATETIME as CREATETIME4_35_, daamunifor0_.CREATOR as CREATOR5_35_, daamunifor0_.DATAAREA as DATAAREA6_35_, daamunifor0_.DATAPATH as DATAPATH7_35_, daamunifor0_.DATASOURCEID as DATASOURCEID8_35_, daamunifor0_.DBTYPE as DBTYPE9_35_, daamunifor0_.RESDESC as RESDESC10_35_, daamunifor0_.TABLECODE as TABLECODE11_35_, daamunifor0_.TARGETID as TARGETID12_35_, daamunifor0_.TYPE as TYPE13_35_, daamunifor0_.UPDATETIME as UPDATETIME14_35_, daamunifor0_.UPDATOR as UPDATOR15_35_ from DAAM_UNIFORMRES daamunifor0_ where 1=1 and ( daamunifor0_.CAPTION like '%()-\/&<>#%' escape '[') order by daamunifor0_.UPDATETIME DESC ) where rownum <= 10
参考:
https://blog.csdn.net/hyman_c/article/details/103137989