On Fri, Sep 30, 2011 at 09:27:22PM +0530, Gopakumar Pandarikkal wrote:
> why dont you use regular expression for perfectly validating an email id ?
>
> here is a n example
>
> SELECT email_address
> 2 ,
> regexp_substr(email_address,'[a-zA-Z0-9._%-]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}')
> substr_result
>
>
> 3 FROM email
> 4 /
email address verification is really hard [1]. The Regex above excludes some
TLDs for example (.museum, .travel, or some of the new IDNA TLDs
.XN--LGBBAT1AD8J)
Also "foo bar"@example.com es perfectly valid.
etc.
don't do that.
[1] Here you can find a hopefully correct Regex:
http://www.ex-parrot.com/~pdw/Mail-RFC822-Address.html
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
