Oracle escape characters

Definition: 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. Instance: SQLselect * fromt11wherenamelike % _ %; NAME ---------- aa_aaaaSQLselect * fromt

Definition: 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 characters usually use '/', but other symbols can also be used. Instance: SQL select * from t11 where name like '% _ %'; NAME ---------- aa_a aaa SQL select * from t

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

The definition of escape characters is usually '/', but other symbols can also be used.

Instance:

SQL> select * from t11 where name like '% _ % ';

NAME
----------
Aa_a
Aaa
SQL> select * from t11 where name like '%/_ %' escape '/';

NAME
----------
Aa_a

NOTE: If '/' is used as the search character, '/' must be used as the escape character, and the same is true for the forward slash.
Select * from wan_test where psid like '% // %' escape '/'