SELECT first_name, last_name
FROM employees
WHERE REGEXP_LIKE (first_name, ‘^Ste(v|ph)en$‘);
FIRST_NAME LAST_NAME
-------------------- -------------------------
Steven King
Steven Markle
Stephen Stiles
原文：http://www.cnblogs.com/john2017/p/6371618.html