Check validity of email address

check-email.sql

SELECT *
  FROM EMAIL_TO_CHECK ETC
 WHERE ETC.EMAIL IS NOT NULL AND ETC.EMAIL <> 'NA' AND ETC.EMAIL <> 'N/A'
       AND (   ETC.EMAIL IS NULL
            OR ETC.EMAIL NOT LIKE '%@%'
            OR ETC.EMAIL LIKE '%@%\_%' ESCAPE '\'
            OR ETC.EMAIL LIKE '%.'
            OR LOWER (ETC.EMAIL) LIKE '%@%.co'
            OR LOWER (ETC.EMAIL) LIKE '%@%.co.hk'
            OR LOWER (ETC.EMAIL) LIKE '%@%.co.mo'
            OR LOWER (ETC.EMAIL) LIKE '%@%.co.cn'
            OR LOWER (ETC.EMAIL) LIKE '%@%.co.my'
            OR LOWER (ETC.EMAIL) LIKE '%@%.co.au'
            OR LOWER (ETC.EMAIL) LIKE '%@%.co.tw'
            OR LOWER (ETC.EMAIL) LIKE '%@%.com.jp'
            OR (NOT REGEXP_LIKE (LOWER (ETC.EMAIL), '\.[a-z][a-z]$'))
               AND (NOT REGEXP_LIKE (LOWER (ETC.EMAIL), '\.[a-z][a-z][a-z]$')
                    AND LOWER (ETC.EMAIL) NOT LIKE '%.asia'
                    AND LOWER (ETC.EMAIL) NOT LIKE '%.info')
            OR (    REGEXP_LIKE (LOWER (ETC.EMAIL), '\.[a-z][a-z][a-z]$')
                AND LOWER (ETC.EMAIL) NOT LIKE '%.com'
                AND LOWER (ETC.EMAIL) NOT LIKE '%.biz'
                AND LOWER (ETC.EMAIL) NOT LIKE '%.edu'
                AND LOWER (ETC.EMAIL) NOT LIKE '%.mil'
                AND LOWER (ETC.EMAIL) NOT LIKE '%.org'
                AND LOWER (ETC.EMAIL) NOT LIKE '%.net'
                AND LOWER (ETC.EMAIL) NOT LIKE '%.gov'
                AND LOWER (ETC.EMAIL) NOT LIKE '%.pro'))