Oracle 转义字符
时间:2022-03-14 03:23
id
sfds_V_SF
ASD_V_DSAF
SD_V_DSAD
下划线是Oracle特殊字符,需要转移,如下
select * from systab t where t.id like ‘%_V_%‘
改为
select * from systab t where t.id like ‘%/_V/_%‘ ESCAPE ‘/‘