In this Oracle APEX Tutorial, We will explore about the Email Validation in Oracle APEX with Example.
We know that E-mail Validation is a very important part of the signup or registration page actually most of the time we need to insert user email information in our database for the unique visitors.
Email Validation in Oracle APEX with Example
Actually, We are using Regular Expression for validating email address in Oracle APEX. Use the Following Regular Expression.
^[A-Za-z]+[A-Za-z0-9.]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$
Step 1:- Create a Page with a text field Item and also create a button. Below Screenshot will help you out for better understand.
Step 2:- Now choose an email item, right-click with the mouse, and create a validation. The below screenshot will help you out to better understand.
Step 3:-After creating a validation choose Item Matches Regular Expression validation type and Select P21_EMAIL Item and copy the above regular expression code in the regular expression section. Below Screenshot will help you out.
Step 4:- Now you have to run your page and check that if you write the correct email address then it will display a success message otherwise it will display an error message. Below Screenshot will help you out for better understand.
That's all for today, I think(Email Validation in Oracle APEX with Example) post will helpful for you. If you like the post then share your view in the comment box.
We have already upload a video on this topic if you want to watch that video then click here. Please support our youtube channel so we will upload more Oracle APEX Tutorial videos and blog.
4 Comments
You forgot to show us the PL/SQL code for the email validation, please kindly provide us with that. Thank you.
ReplyDeleteUse below code in Item matches regular expression.
ReplyDelete^[A-Za-z]+[A-Za-z0-9.]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$
how can i create a validation for a unique Email ?\
ReplyDeleteI need to accept a mail with "-" or "_"
ReplyDeleteIf you have any doubts, Please let me know