Use LIKE Conditions in Oracle

Q

How To Use LIKE Conditions in Oracle?

✍: FYIcenter.com

A

LIKE condition is also called pattern patch. There 3 main rules on using LIKE condition:

  • '_' is used in the pattern to match any one character.
  • '%' is used in the pattern to match any zero or more characters.
  • ESCAPE clause is used to provide the escape character in the pattern.

The following script provides you some good pattern matching examples:

SELECT CASE WHEN 'FYICenter.com' LIKE '%Center%' 
  THEN 'TRUE' ELSE 'FALSE' END FROM DUAL;
TRUE   

SELECT CASE WHEN 'FYICenter.com' LIKE '%CENTER%' 
  THEN 'TRUE' ELSE 'FALSE' END FROM DUAL;
  -- Case sensitive by default
FALSE

SELECT CASE WHEN 'FYICenter.com' LIKE '%Center_com' 
  THEN 'TRUE' ELSE 'FALSE' END FROM DUAL;
TRUE   

SELECT CASE WHEN '100% correct' LIKE '100\% %' ESCAPE '\' 
  THEN 'TRUE' ELSE 'FALSE' END FROM DUAL;
TRUE   

 

Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-16, 226👍, 0💬