Introduction to Oracle escape character usage

The following articles mainly introduce the escape characters of Oracle escape and the actual usage and definitions of the Oracle escape keywords, we all know that the Oracle escape keyword is often used to make certain special characters, such as wildcards:

'%', '_' Escape is the meaning of their original characters. The defined escape characters generally use '\', 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 '/'  
 
 

The above content is the description of the Oracle escape character, hoping to help you in this regard.