The Regular Expression Commands

REGEXP_LIKE(expr, pattern)

REGEXP_INSTR(expr, pattern , start)

REGEXP_SUBSTR(expr, pattern , start)

REGEXP_REPLACE(expr, pattern, replace, start)

Here are the Regular Expressions commands

The 2 primary parts here are the Expression, which is just the data you are looking at in the database, most likely a field AND the pattern, which is the pattern you are looking for in the data

For example the pattern in a sting of “Avenue”, “Street”, or “Way” might indicate that the string contains an address

The trick is how to code a pattern...