Oracle Application Express

This article will discuss about Oracle Application Express (Getting Started). Oracle Application Express or abbreviated with Oracle APEX is an application environment provided by Oracle Corporation for free.  Oracle APEX can be downloaded  through its website (apex.oracle.com). Oracle APEX is a web-based application whose development is done through a web browser (Mozilla Firefox, Microsoft Internet Explorer, etc.).  Oracle APEX is a separate application from the database, but Oracle APEX has been integrated in Oracle DB XE 11g, when we finished installing Oracle DB XE 11g then Oracle APEX will be installed as well. The Oracle APEX version integrated on Oracle DB XE 11g is Oracle APEX 4.0. The latest version now is Oracle APEX 5.1.

Oracle APEX able to create web-based applications components:  workspace management, user management, database object management (tables, view, procedure, function, etc.), application creation (form, report, chart, etc.) to security settings of applications made it.

The First Login

Before proceeding to interact with Oracle APEX, make sure you can login into Oracle APEX. Here are the steps to login to Oracle APEX:

1. From web browser (Mozilla Firefox, Google Chrome, etc), open  http://localhost: 8080/apex/apex_admin. An Oracle Application Express login form will appear.

2. Fill username field with "admin" and password with password field that you set while installation process, then click Login button.

3. You will be prompted to change the ADMIN password.

The new password must be met these terms:
a. Minimum 8 characters
b. There is at least a capital letter
c. There is at least 1 number
d. There's at least 1 special character (! "# $% () '* +, - / :; <=>? _)
e. Cannot contain element username

4. After successfully changing the password, re-login by using a new password

5. Welcome page will be displayed when the login is successful 

That’s all for the introduction of Oracle APEX. First things you have to do is changing the admin password for INTERNAL workspace (step number 3). Next thing you have to do is creating new workspace.

Thank You - Bobsis