/*Return distinct email domain name using regular expression*/ SELECT DISTINCT (REGEXP_SUBSTR (EMAIL_ADDR, '(@)\w+[\.-]\w+\.?\w+\.?\w+')) FROM SCHEMA.TABLE_NAME;