Ref:
1.validation on email / postcode fields in sql/oracle
validation on email / postcode fields in sql/oracle - Stack Overflow
2.email validation check with Oracle regular expressions
email validation check with Oracle regular expressions (dba-oracle.com)