-- search for Social Security Numbers (xxx-xx-xxxx)
SELECT * 
FROM sandbox
WHERE REGEXP_LIKE(regex_test,'^[0-9]{3}-[0-9]{2}-[0-9]{4}$');
 
 
-- match US phone number with or without parentheses
SELECT * 
FROM sandbox
WHERE REGEXP_LIKE(regex_test,'^\([0-9]{3}\)[:space:]?[0-9]{3}(-|[:space:])?[0-9]{4}$|^[0-9]{3}-?[0-9]{3}-?[0-9]{4}$');
 
 
-- match US ZIP codes 
SELECT * 
FROM sandbox
WHERE REGEXP_LIKE(regex_test,'[0-9]{5}(?-[0-9]{4})?');
 
-- handy pattern for matching an IP address:
'(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)'