Regexp_Like : REGEXP_LIKE « Regular Expressions Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Regular Expressions Functions
  3. REGEXP_LIKE

The complete function definition is:

REGEXP_LIKE(String to search, Pattern, [Parameters]),

where

String to search, Pattern, and Parameters are the same as for REGEXP_INSTR.

As with REGEXP_INSTR, the Parameters argument is usually used only in special situations.









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,}')