在oracle数据库上验证电子邮件字段 [英] validate email field on oracle database

问题描述

你好朋友，

我有大约400,000个邮件地址列表属于我的客户

加载在oracle数据库中。





我如何以简单的方式验证这一点。

（看看这封电子邮件是否存在？）





非常感谢

Hello friends,
I have list of about 400,000 mail address belong to my customers
loaded in oracle database.


How can i validate this lest in easy way.
(see if this email is exist or not ??? )


thanks alot

推荐答案

您可以验证域名使用DNS查找的电子邮件地址的一部分。多年前我使用从MelissaData购买的组件做了这个。



不容易的方式

我知道无法验证个人电子邮件地址而不向他们发送实际的电子邮件消息（如果您想留在我们的电子邮件列表中，请单击此处）。



Bouncebacks表示邮箱不可用。这不是万无一失的，因为他们的邮箱服务器可能已经脱机，有些公司已经关闭了邮件服务器的反弹功能。



如果你给他们发了一条消息，你就是可以在每封电子邮件中引用一个唯一命名的图像（每个电子邮件地址一个），并挖掘W3SVC日志以记录加载这些唯一命名图像的尝试。您的服务器上不必存在该映像。这不是万无一失的，因为有些人在他们的浏览器中关闭了图像加载，有些人在没有阅读的情况下删除了电子邮件。在此之前请咨询贵公司的律师，因为有些公司对从公司发送给客户的电子邮件有严格的政策。

You can validate the domain name portion of the email address using a DNS Lookup. I did this many years ago using a component purchased from MelissaData.

No Easy Way
I know of no way to validate individual email addresses without sending them an actual email message ("Click here if you want to stay on our emailing list").

Bouncebacks indicate that the mailbox was unavailable. It is not foolproof because their mailbox server could have been offline and some companies have turned off the bounceback capability of their mail server.

If you send them a message, you could put a reference to a uniquely named image (one for each email address) in each email message and mine the W3SVC logs to record attempts to load those uniquely named images. The image does not have to exist on your server. This is not foolproof because some people have image loading turned off in their browsers and some people delete email messages without reading them. Check with your company''s attorney before doing this as some companies have strict policies on email messages sent from the company to customers.

SMTP协议支持可用于的VRFY命令验证电子邮件地址。可悲的是，垃圾邮件发送者滥用它来收集电子邮件或黑客收集用户名。所以它已经在许多邮件服务器上被禁用了，如果你多次使用它，一些服务器甚至可能会将你列入黑名单。

但它可能值得一些研究。

The SMTP protocol supports the VRFY command which can be used to verify an email address. Sadly enough it has been misused by spammers to harvest emailaddresses or by hackers to harvest usernames. So it''s been disabled on many mailservers, and some servers might even blacklist you if you use it to many times.
But it might be worth some research.

这篇关于在oracle数据库上验证电子邮件字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！