A LIKE condition is also called pattern patch. There are 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 tutorial exercise provides you some good pattern matching examples:SELECT 'GlobalGuideLine.com' LIKE '%center%' FROM DUAL; 1SELECT 'GlobalGuideLine.com' LIKE '%CENTER%' FROM DUAL; 1 -- Case insensitive by defaultSELECT 'GlobalGuideLine.com' LIKE '%CENTER_com' FROM DUAL; 1
A LIKE condition is also called pattern patch. There are 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 tutorial exercise provides you some good pattern matching examples:SELECT 'GlobalGuideLine.com' LIKE '%center%' FROM DUAL; 1SELECT 'GlobalGuideLine.com' LIKE '%CENTER%' FROM DUAL; 1 -- Case insensitive by defaultSELECT 'GlobalGuideLine.com' LIKE '%CENTER_com' FROM DUAL; 1
Comments Received:
Please give your suggestions and feedback: