REGEXP_LIKE « Regular Expressions Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Regular Expressions Functions
  3. REGEXP_LIKE
18.3.REGEXP_LIKE
18.3.1.REGEXP_LIKE(x, pattern [, match_option]) searchs x for the regular expression pattern.
18.3.2.Regexp_Like
18.3.3.Asking for the presence of a 'g' or a 'p'
18.3.4.Asking for the presence of a 'g' or a 'p' with REGEXP_LIKE
18.3.5.Retrieves employees whose first name starts with J or j.
18.3.6.regexp_like(comments, ' f[a-z]* ','i')
18.3.7.regexp_like(comments, '([^ ]+ ){8,}')
18.3.8.Using regexp_like(comments, '([[:alnum:]+[:punct:]]+[[:space:]]+){8,}')