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 '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:

2009-2016 downloadmela.com. All rights reserved.