APP DEVELOPMENT IN 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 developing mobile, desktop, web applications.by using oracle it is possible to create a application just using low code. With lesser knowledge about SQL & databases will help you efficiently to create a application using oracle apex.

Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You won't need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest

 

What is low code?

Low-code is a visual approach to software development that optimizes the entire development process to accelerate delivery.

 

Why low code over traditional coding?

Low code is 10 times faster compared to traditional coding.

By 2024 65%of app development will use low code development method

Great quality and consistency

Easier to learn

Development cost is less

More reliable way of development

More flexibility

 

Oracle-apex availability:

Apex is available with every oracle database.

It is free of cost and fully supported feature all supported database editions and versions. There is no limit for developers and end users.

It is available in all database cloud services, it will run on premises , oracle cloud and other clouds.

 

Application development with oracle apex:

The Oracle APEX Application Development service provides a preconfigured, fully managed, and secured environment in Oracle Cloud to build and deploy world-class applications

Creating a workspace:

First you need to create a oracle apex workspace . You can request a free workspace on cloud or you can download and install on your system locally.

Now that you have an environment ready, let's get some data into our workspace that you can use to build your first application

 

Oracle –Apex app builder:

Using oracle apex app builder you can develop applications in three ways.

1. New Application-Creating A New One From Scratch,

2. Create From A File-You Can Start With A Spreadsheet, Xml, Or JSON And Upload It As The Basis For Your Data Model.

3. Starter App-installing the sample application and customize the app based on your need.

 

Type:1 - New Application

To create a new application first you need to get the data into your workspace. You can use SQL Workshop to create data.

 

SQL Workshop:

SQL Workshop allows you to create, view, and maintain your database objects. All you need is your web browser. Simply sign into your workspace and you're in! This provides incredibly fast and easy access to Oracle Database from the public internet.

SQL workshop home page has the following tools.

  

1. Object Browser:

Object browser enables you to create, browse and edit objects in oracle database. Object browser is divided into two parts one on the left side is object selection part, one on the right side is detail part.

Object selection part lists the objects for the selected type  in the database you filter the objects based on your need.

Detail part shows the entire detail of the selected object, it will shows the detail table and the data, you can add ,modify ,delete data from the table using the object browser features.

You can create new table using  object browser  by following the steps of the wizard.

 

2. SQL Commands:

SQL commands are used for create ,view , modify ,delete database data in oracle database. The SQL commands home page contains two sections one is command editor and the another one is display section.

 The command editor is used for executing the SQL commands.

 The SQL command you enter can be used to create, edit, view, run, and delete database objects. Both Database Manipulation Language (DML) and Database Definition Language (DDL) commands can be executed.

Display sections used to view the output by the SQL commands.

You can save and download the SQL queries.

3. SQL Scripts:

A SQL script is a set of SQL commands saved as a file. A SQL script can contain one or more SQL statements . You can use SQL scripts to create, edit, view, run, and delete database objects. You can easily create new scripts from scratch, or upload existing files. When you run a script then you are presented with a results page which displays each statement run and the feedback for that statement.

Click on Create App button from within the Script Editor to parse your SQL script and create an App in just few clicks.

Creating The Application:

Now that you have data available in your workspace, you can use the Create App wizard to create your first application. Once you've created your app, use Page Designer to further enhance your application pages. From Page Designer, you can quickly run your page to see your changes immediately in a new browser tab

Steps:

Click create app builder

Click new application give application name

Click add a page

Select page format based on your vision (form, report ,chart, grid, search )

Give a page name, add the data table then click create

You app will be created with the page you created using page designer you can customize you application. You can also create multiple pages to you application based on your vision.

 

Type -2: Creating From A File:

 

Steps:

Click create app, select from a file.

Choose the file which contains the data for your application.

Then the data from the file will be stored in a database table.

Give a table name, then load the data into the table.

View the table and create the application using that table data.

Then run the application, Using page designer customize your application pages.

 

 

Type-3: Using Starter App:

In this method you will download and install a sample application from the oracle apex and customize the sample apps using page designer based on your vision.

Steps:

Click create from starter app

Download and install the sample app which is similar to your vision.

Then run the application and customize the sample app to your need.

Conclusion:

Oracle apex provides us a faster and consistent way for developing applications with lot of features .you don’t need to be an expert in developing learning oracle apex is very simple. A person with less amount of SQL knowledge can build a application with high performance and high flexible.