Correct use of Oracle ESCAPE characters and ESCAPE keywords

The following articles mainly introduce the actual operations of the Oracle ESCAPE character and the actual usage of the escape keyword in Oracle Database. We all know that the ESCAPE keyword is often used for some special characters, such as wildcards: '%', '_' escape them as 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 '/'  
 
 

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