Home » SQL & PL/SQL » SQL & PL/SQL » Validate Email
Validate Email [message #184155] Tue, 25 July 2006 09:54 Go to next message
Messages: 66
Registered: July 2006
Hi Friends,

I need to validate the entered email is valid or not.

Re: Validate Email [message #184158 is a reply to message #184155] Tue, 25 July 2006 10:04 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
All you need is a complete list of all the email addresses that exist, and away you go.

I had one, but I think I misplaced it. Cool

Seriously, how do you intend to do this?
You can check that the general format is correct, (leading section containing no unusal characters, followed by an '@', followed by a trailing ection containing no unusual chrs) but I can't see how you can hope to get further than that,

You can try sending an email and waiting an arbirtary amount of timeto see if you get a failure message, but the failure message won't be readable from the DB.
Previous Topic: Pass substitution variables from shell script to the SQL
Next Topic: Problem with query
Goto Forum:

Current Time: Sat Aug 19 23:15:50 CDT 2017

Total time taken to generate the page: 0.49421 seconds