Ticker

6/recent/ticker-posts

How to Create User Registration Page in Oracle APEX 20.1 - Javainhand Tutorial

How to Create User Registration Page in Oracle APEX 20.1

Welcome to Javainhand.com, Today I will share with you how to create a user registration page in Oracle APEX 20.1.

About Registration Page

The registration page is essential for every web application and mobile application.you can take many live examples on the internetMost of the websites have a registration page. Registration Page helps to save user information and identification.

How to Create User Registration Page in Oracle APEX 20.1?

In this Oracle APEX Tutorial, I will share the complete process of creating a user registration page in Oracle APEX 20.1 where users create an account with providing some simple input information.

In this User Registration Page, I will create only four input fields email id, mobile number, password, and confirm password. you can add more input fields based on your requirement.

Step 1:- For this tutorial, I am using the USER_REG table where email_id is my table primary key.you can see the below table structure.

CREATE TABLE "USER_REG"
( "EMAIL_ID" VARCHAR2(100),
"MOBILE_NUMBER" VARCHAR2(10),
"CONFIRM_PASSWORD" VARCHAR2(100),
"PASSWORD" VARCHAR2(100),
USING INDEX ENABLE
CONSTRAINT "USER_REG_CON" PRIMARY KEY ("EMAIL_ID") ) /



Step 2:- After the creating table successfully, Now we have to add one button which name is user registration. You can match that from the following screen.



Step 3:- Create a page with form type.you can match the following screen. On this screen, you have to choose which page you want to create in your application.



After the click on the Next button, you have to see the following screen.on this screen, you have to select a form type page.



Again the click on the Next button, you have to see the following screen. On this screen, you have to enter your page name, page mode(Normal or Modal Dialog), branch, and cancel button.



Again the click on the Next button, you have seen the navigation menu entry page where we have the option to select that you want to display your page in the navigation menu or not. But here we don't want to add my registration page in the navigation menu then I am selecting (Do not associate this page with a navigation menu entry) option. you have to see the following screen.



Again the click on the Next button, you have to see the Data Source screen. Here you have to enter the table name which you want to create form.you can match the following screen.



Again the click on the Next button, you have to see the Columns and Primary Key Screen. In this screen, you have to select which column you want to display on the screen and define your table primary key. As you see on the following screen I am selecting all my columns to display and select email_id as the primary key.



Now click on the create button and your user registration page has been created.you can match the following screen.



Note:-Whenever you have to call any page before the authentication then you need to change the page authentication page. If you see your current page authentication property is set(Page Requires authentication) then we have to change authentication property(Page is Public). you can match the following screen.



Now run your page and you will see that your registration page has been created.

Step 4:-After the creating registration page you have to call the registration page on the login user registration button.you have to change button behavior and redirect to page 6(Here you can pass your page number).you can match the following screen.

Action:-Redirect to page in this application
Target:-6(Pass your application page number)



That's All, here I have shared a simple user registration page in oracle apex 20.1. Based on your requirements, you can change page-item templates. You can also add validation like control duplicate records, email validation, mobile number validation, follow password policy, confirm password validation, and more validation.

If you like this tutorial then please tell me the comment box and also share it with your friends.

Oracle APEX Validation Post:-
Email Validation in Oracle Apex with Example
Password Validation in Oracle Apex with Example
Confirm Password Validation in Oracle Apex
Mobile Number Format Validation in Oracle Apex

Post a comment

2 Comments

  1. Hello Team,

    Thank you for the explanation.

    Could you please let me know how to restrict the edit access to the registered users? Only Admin should have the privilege to edit the page.

    Thank you in advance.

    Regards,
    Ajay

    ReplyDelete

If you have any doubts, Please let me know