# ORACLE daily # ESCAPE usage

Purpose: The escape keyword is often used to make some special characters, such as the wildcard: %, _ escape is the meaning of their original characters. The defined escape characters are usually used, however, you can also use other symbols (either letters or numbers ). SQLSELECT * FROMempWHEREenameLIKEa % ESCAPEa; EMPNOENAMEJOBMGRHIR

Purpose: The escape keyword is often used to escape certain special characters, such as wildcards: '%' and '_', as the meaning of their original characters, the defined escape character '\' is usually used, but other symbols can also be used (either letters or numbers ). SQL SELECT * FROM emp WHERE ename LIKE 'a % 'escape 'a'; EMPNO ENAME JOB MGR HIR

Purpose: The escape keyword is often used to escape certain special characters, such as wildcards: '%' and '_', as the meaning of their original characters,

The defined escape character '\' is usually used, but other symbols can also be used (either letters or numbers ).

SQL> SELECT * FROM emp WHERE ename LIKE 'a % 'ESCAPE 'a ';

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----------------------------------------------------------------
7935% cc clerk 7782 1200.00 20

ESCAPE 'A' ESCAPE the wildcard % character