Oracle 获得以百分号结尾的脚本有三种写法

SELECT * FROM TEST WHERE SUBSTR(NOTE ,-1) = CHR(37);

SELECT * FROM TEST A WHERE A.NOTE LIKE '%/%' escape '/';

SELECT * FROM TEST WHERE REGEXP_LIKE(NOTE,'%$');