Create an application using Oracle APEX.

 What IS Oracle APEX?

Oracle APEX: Oracle Application Express.

Oracle APEX is a low code or no code web development framework developed by oracle. It is used for creating Mobile, Desktop, and Web Applications. It is a free Oracle database feature. Oracle APEX comes with several pre-built productivity app examples, including a survey builder, bug tracking, and project management with P-Track.

Create Application With Oracle APEX:

Steps to create Application:

• Create a workspace
• Create table/ import data
• Create an Application with SQL data

Create a workspace:

• Click on the below link to create an Apex space, and yow redirect to the main APEX page.

https://apex.oracle.com/en/learn/getting-started/

First, we need to create an oracle APEX workspace. We can create a free workspace on the cloud or we can download and install it on our system. Click on Request a free Workspace or Download and install Oracle APEX locally.

We get a registration page after clicking on the request for a free space.

Enter the First name, last, name, and required details. Check mail you will receive an account activation link. After completing the registration you need to confirm your password, the Apex workspace interface is like this.

The workspace contains mainly:

• First we need to create a table/ data. Go to SQL WORKSHOP and select Object Browser for creating Tables.
• We have four ways of creating a table using:

1.       Object Browser

2.       SQL Commands

3.       SQL Scripts

4.       Utilities

I am using Object Browser for creating Tables.

• Click on the + symbol for creating a new table, Enter Table Name, and Column Name, and select data type, Scale, and identity. Click on the Next button and select the primary key, Foreign key, and Constraint names.

• By using SQL Commands, and SQL Scripts we can create SQL tables.

APP BUILDER:

App builder contains:

• Create App
• Import
• Dashboard
• Workspace Utilities

CREATE APP:

Create an app containing:

• New application
• From a File
• Starter App

Steps to create an app:

• Click on create a new application.
• In this way, we use SQL table data, that is created in SQL Workshop. We select a page style, and application features to like about the page, feedback, theme style selection, etc.

• Click on Add page, we have different types of page formats available. I am now using the Form type page.

• Give page name and select Table, and click on.

• If we want to change the application Appearance, click on the APPEARANCE section. We have three options in the appearance sections:

1.       Theme Style

2.       Navigation Style

3.       Use a custom Theme.

• I am using vita style, side menu Navigation style. If we want additional pages to click on Add Pages. I am adding additional 7 pages: Customer Details, Reservation Info, Room Info, Owner Info, Dashboard, Employee Info, and Payment Info.
• We can add Logos, and change names to pages.
• I am adding features also, the features are already built-in workspace.
• Click on Create Application after modifying all the settings. The page Designer interface is like this.

• We can add images, and buttons in Page Designer.
• After modifying all data click on Save and Run Page (alt+f₈).

This is my Application interface. And collected data.

FROM A FILE:

Steps to create an Application by using this method:

• Click on Choose File, and we upload a CSV, XLSX, XML, or JSON file or Copy and paste the data, automatically application is created and if we need any changes we can modify it in the Page Designer section.

STARTER APP:

We have available many samples and starter apps in this section. We download and install a sample app from the Oracle APEX and modify the Application.

CONCLUSION:

Oracle APEX is a low code or no code web development framework developed by oracle. It is used for creating Mobile, Desktop, and Web Applications. We can create Apps without using coding. It enables you to build scalable, secure enterprise apps, with world-class features. It is easy to build applications.