Monday, December 24, 2018

How To Create Workspace User in Oracle APEX

Leave a Comment

This article will describe about How To Create Workspace User in Oracle APEX. You will get one workspace when you are successfully register on Oracle APEX website ( On Oracle Application Express, all of your applications and data will be combined on 1 application workspace. This workspace will have a correlation with your database schema. One workspace will be mapped into one schema, but one schema might be used by several workspace.

Workspace can be analogically as a garage. On a garage there will be stored some tools, a vehicle or some furniture (chair, desk, etc.) or anything you want to place in it. Garage will be secured with a special door with a key. To enter the garage you must open the door with a correct key, without a correct key you will not be able to enter the garage. You may allow another person to enter the garage by giving the duplicate of the key.

Okay let we start to create a workspace user on Oracle APEX, here are the steps:
1.       Sign In into your existing workspace with your username and password

2.       Click on Manage Users and Groups option, it located on the right top of your Oracle APEX dashboard. Click on the head with dropdown menus (3rd from the right) and you will get the menu.

3.       Now you will be at “Manage Users and Groups” page. You will find existing users there. Click on Create User button (blue button) on the top right to start the process.

4.       Next on User Identification section you need to fill some information. Fill the desired username and your valid email address, these fields are mandatory. Next Click on Account Privileges tab.

5.       On Account Privileges section, you must choose some options. Choose the default Database Schema, decide whether the user is workspace administrator or not. The one thing for sure is you must choose the user as a developer to give the user access to be able to create some applications. Next click on the Password tab.

6.       On the Password tab, set your desired password. It must be unique password, consist of 8 character with combination of uppercase, lowercase, number and special character (e.g. *). Click on Create User blue button to complete the process.

7.       Now you will find new user you just created. To create another user, you can repeat the process by clicking the Create User Button.

8.       It’s time to check your new user. Sign out from existing user by clicking on Sign Out button under currently connected user (top right corner). Sign In with your new user on the Oracle Application Express Sign In form.

9.       If you are entering the correct username and password combinations you should be able to enter the Oracle Application Express dashboard as a developer.

That’s all for the process of HowTo Create Workspace User in Oracle APEX. Hope it’s clear enough for you to manage your workspace users.
Thank You - Bobsis

Read More

Monday, December 3, 2018

First Step to Learn Oracle APEX (Create a Workspace)

Leave a Comment

This article will describe about first step to learn Oracle APEX (Create a Workspace). Before you can develop any application with Oracle Application Express (APEX), you must have a workspace to deploy your application. As we know that Oracle APEX is integrated with Oracle Database, every application develop with Oracle APEX, automatically will be stored in Oracle Database along with the application data.

Oracle APEX is a free web-based development environment. As long we have authentication credential to the Oracle APEX server, we can develop our application anywhere in the world using a web browser. To obtain the workspace, we need to request the free request by accessing website.

Now let’s start to request our free workspace. Here are the steps:

1.       Open the website - the click on Get Started for Free blue button

2.       Next click on the Request a Free Workspace button

3.    We will find the Request a Workspace form. In the Identification section, fill your identity and your desire Workspace name. Click on Next button when you are done.

4.       In the next form we will be asked to fill some survey questions. Answer the survey then click on Next button.

5.       Next you must write something about why you are requesting the workspace. You may answer it by type “I need it for learning purposes” or something like that. Click on Next button when you’re done.

6.       After your information recorded, next step is agreement confirmation. You have to click on I accept the terms (please scroll the terms and read it) then click on Next Button.

7.       The final step of workspace request is reading the Confirmation page. Make sure the information shown is the same as your desire. Click in Submit Request Button to finalize the request.

8.       Notification will be shown, next you have to check you mailbox to activate the workspace.

9.       Open an email sent from, it will stated that you workspace request approved. You have to click on the given link, it will be redirected to oracle apex website.

10.   Congratulation! Your free Oracle APEX Workspace has successfully created. Click on Continue to Sign In Screen button to enter your workspace.

11.   Because it is your first time to access the workspace, you need to change your initial password. Please enter your new password then click on Apply changes button. In the future this process will not be needed, you can change your password only when you need to change it.

12.   Here is your Oracle APEX Workspace desktop, now you can start to create your Oracle APEX application.

Okay that’s all the processes to create free Oracle APEX Workspace. This is the first step to learn Oracle APEX.

Thank You - Bobsis

Read More