Home > IT Answers > Development > pl/sql code for email id validations
Raffee
5 pts.
 pl/sql code for email id validations
Code, Email ID validation, PL/SQL
i need pl/sql procedure that validates the email id is correct or not?

Software/Hardware used:
ASKED: June 4, 2008  5:58 AM
UPDATED: February 9, 2011  9:37 AM
RELATED QUESTIONS
Answer Wiki:
The following performs a boolean test for a valid email address in the email column: REGEXP_INSTR(email, 'w+@w+(.w+)+') > 0, use this in your own procedure.
Last Wiki Answer Submitted:  June 24, 2008  12:14 pm  by  Vini Chandamama   100 pts.
All Answer Wiki Contributors:  Vini Chandamama   100 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Just keep in mind that this validates just the email address format, and if that is correct, it has no way to know if the address really exists.

carlosdl
 63,535 pts.
 

I am looking for a plsql function that can validate the format of an email address.

JTFJR
 10 pts.