How To Use LIKE Conditions

  • 15 Mar, 2012

    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 '' LIKE '%center%' FROM DUAL; 1SELECT '' LIKE '%CENTER%' FROM DUAL; 1 -- Case insensitive by defaultSELECT '' LIKE '%CENTER_com' FROM DUAL; 1

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 All rights reserved.