Validating multiple email addresses
This is your original expression, changed so that it allows several emails separated by semicolon and (optionally) spaces besides the semicolon.It also allows a single email address that doesn't end in semicolon. You can change the final * by to require at least one address.For instance, here's one option using a regular expression: FUNCTION val_email_string (p_email IN VARCHAR2 ,p_separator IN VARCHAR2 DEFAULT ',') RETURN VARCHAR2 IS lt_emails apex_application_global.vc_arr2; lb_valid BOOLEAN DEFAULT TRUE; ln_error PLS_INTEGER; BEGIN -- split string into separate addresses lt_emails := apex_util.string_to_table (p_string = FOR i IN 1..lt_emails.
Now for your original question, I would recommend a preprocess stage where you split on reasonable delimiters (',' and ';'), trim whitespace (at least if dealing with user input) and validate each entry.
Email validation will also help you protect your email sender score.
A recent study conducted by Return Path shows that in 83% of cases, low email sender reputation is responsible for emails not reaching their intended recipient.
It is used to identify the devices of a network through an addressing system.
IPv6, often referred to as the “next generation” Internet standard, is the successor of IPv4.