Home
Ask a Question
IT Answers
IT Blogs
Tags
My Watchlist
Member Login:
e-mail:
password:
Register
Forgot Password
SEARCH
for
in
IT Blogs
IT Answers
IT Knowledge Exchange
How to use this site
Home
>
IT Answers
>
Oracle
> pl/sql code for email id validations
Help
Question
Asked:
Jun 4 2008
5:58 AM GMT
Asked by:
Raffee
pl/sql code for email id validations
PL/SQL
,
Code
,
Email ID validation
i need pl/sql procedure that validates the email id is correct or not?
Add to My Watchlist
Report Objectionable Content
RSS - Question Updates
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
E-mail me updates on this question
E-mail me new questions and answers on this tag/topic
SUBSCRIBE
hidden modal window
Help
Answer Wiki (Improve, edit or add to this answer)
IMPROVE THIS ANSWER
View History
RATE THIS ANSWER
0
Click to Vote:
0
0
Last Answered:
Jun 24 2008 12:14 AM GMT
by
Vini Chandamama
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.
Browse more Questions and Answers on
Oracle
and
Development
.
Looking for relevant
Oracle
Whitepapers? Visit the
SearchOracle.com Research Library
.
RSS - Discussions
Help
Discuss This Answer
You must be logged-in to discuss a question.
Log-in/Register
Help
Ask a Question
Question Title:
(150 char limit)
Question: ( Be Specific! )
Tags:
Separate each tag with a comma.
What is a Tag?
Enter all the tags that best match your question topic.
ASK QUESTION
Browse IT Answers by Topic
AS/400
Channel
CIO
CRM
Database
DataCenter
DataManagement
Development
Exchange
Linux
Lotus Domino
Microsoft Windows
Mobile
Networking
Oracle
SAP
Security
SQL Server
Storage
Virtualization
VoIP
>>
VIEW ALL TAGS