REGEXP_LIKE « Regular Expressions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Regular Expressions
  3. REGEXP_LIKE
1.REGEXP_LIKE: The LIKE predicate has an regular expression counterpart
2.Use the negating caret: REGEXP_LIKE(description,'[^mn]')
3.REGEXP_LIKE(TO_CHAR(start_date, 'YYYY'), '^199[5-8]$')
4.REGEXP_LIKE(first_name, '^j', 'i'): First name starts with J or j
5.regexp_like(comments, '([[:alnum:]+[:punct:]]+[[:space:]]+){8,}')