REGEXP_INSTR
Returns the position of the first occurrence of a substring matching the regular expression. Returns 0 if no match is found.
REGEXP_INSTR(expr, pattern)
expr
The string to search in.
pattern
The regular expression pattern to search for.
Examples
SELECT member_name,
REGEXP_INSTR(member_name, 'or')
FROM FamilyMembers;
SELECT member_name
FROM FamilyMembers
WHERE REGEXP_INSTR(member_name, 'or') > 9;