Ticker

6/recent/ticker-posts

Confirm Password Validation in Oracle APEX - Javainhand Tutorial

Confirm Password Validation in Oracle Apex


Welcome to Javainhand, Today I will describe the confirm password validation in Oracle APEX. Most of the websites or social platforms use the confirm password field required on the registration page. Using the confirm password field in the registration or signup page makes the process more secure.

I am comparing the values of the password and confirm the password field using SQL expression in Oracle APEX. If both the field values do not match then the error display on the screen.

SQL Expression in Oracle APEX Example

Using SQL expression validation we compare the values of the password and confirm the password field. Here I am sharing some steps in below that you can easily implement confirm password validation in Oracle APEX.

Step 1:- You have to create a page with a region, two password type page items, and one button. See the below screenshot for better understanding.


Step 2:- Now Click on Confirm Password Page Item and right-click with the mouse. Now choose to create-validation option. See the below screenshot for better understanding.



Step 3:- Now choose the SQL Expression Validation Type. Use the below code in the SQL expression section and give the error message. See the below screenshot for better understanding.
:P30_PASSWORD=: P30_CONFIRM_PASSWORD   // change with your page items


See the following Output


I am sharing the demo URL where you can check or verify the implementation.

That’s all if you like the confirm password validation in Oracle APEX post then please share your view in the comment section and also Share this post with your friends.

Post a comment

0 Comments