Oracle允許在運行時指定轉義字符。
SQL:
SELECT 'YES' FROM DUAL WHERE '50%' LIKE '%/%%' ESCAPE '/';
PL/SQL:
DECLARE
v_string VARCHAR2(20) := '50% OFF';
BEGIN
IF v_string LIKE '%/%%' ESCAPE '/' THEN
DBMS_OUTPUT.PUT_LINE('MATCH');
ELSE
DBMS_OUTPUT.PUT_LINE('NOT MATCH');
END IF;
END;