Ticker

6/recent/ticker-posts

Email Validation in Oracle APEX with Example - Javainhand Tutorial

In this Oracle APEX Tutorial, We will explore about the Email Validation in Oracle APEX with Example.

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.

Email Validation in Oracle APEX

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.

Oracle APEX Email Validation

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.

Oracle APEX Email Validation with Example

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.


Post a Comment

4 Comments

  1. You forgot to show us the PL/SQL code for the email validation, please kindly provide us with that. Thank you.

    ReplyDelete
  2. Use below code in Item matches regular expression.
    ^[A-Za-z]+[A-Za-z0-9.]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$

    ReplyDelete
  3. how can i create a validation for a unique Email ?\

    ReplyDelete
  4. I need to accept a mail with "-" or "_"

    ReplyDelete

If you have any doubts, Please let me know