Scribd
Upload
676 views

Oracle Application Express (Oracle APEX)

Oracle Application Express (APEX) is a rapid web application development tool for the Oracle database. Using only a web browser, developers can create professional applications that are fast, secure, and scalable. APEX was originally called HTML DB and was first released in 2004, allowing HTML tags and CSS to retrieve data from Oracle databases. Over the years, APEX has added many new features and now supports mobile development, interactive reports, and team collaboration. APEX applications can be developed without installing any additional IDEs since the development environment is entirely web-based. The main requirement is knowledge of PL/SQL to develop applications that interface with Oracle databases.

Uploaded by

Amitfusion R13
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
676 views

Oracle Application Express (Oracle APEX)

Oracle Application Express (APEX) is a rapid web application development tool for the Oracle database. Using only a web browser, developers can create professional applications that are fast, secure, and scalable. APEX was originally called HTML DB and was first released in 2004, allowing HTML tags and CSS to retrieve data from Oracle databases. Over the years, APEX has added many new features and now supports mobile development, interactive reports, and team collaboration. APEX applications can be developed without installing any additional IDEs since the development environment is entirely web-based. The main requirement is knowledge of PL/SQL to develop applications that interface with Oracle databases.

Uploaded by

Amitfusion R13
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 13

Oracle Application Express (Oracle APEX) APEX

1- Introduction
In this document, I will introduce Oracle Application Express (Oracle APEX), including technology and
scope of use.

2- What is Oracle Application Express?


Oracle Application Express (Oracle APEX), formerly called HTML DB, is a rapid web application
development tool for the Oracle database. Using only a web browser and limited programming experience,
you can develop and deploy professional applications that are both fast and secure. Oracle application
express combines the qualities of a personal database, productivity, ease of use, and flexibility with the
qualities of an enterprise database, security, integrity, scalability, availability and built for the
web. Application Express is a tool to build web-based applications and the application development
environment is also conveniently web-based

3- History of Oracle APEX


I start the story in 2004 when Oracle brought "HTML DB" to market.

HTML DB made it possible to use HTML tags & CSS in combination with data from the Oracle DB. All you
had to do is to create a package.

A year later they released a version of HTML DB with a graphical user interface. Here we can speak of the
first version of Oracle Apex.
Oracle Application Express (Oracle APEX) APEX

The following years they have improved the user interface and add more new features.
 Charts
 Pdf
 Interactive Reports

It was in 2006 that the name HTML DB changed in Apex (Application Express).

In 2010 Apex is really starting to grow. A lot of people and comunities began to use it as a development tool
for their software.
Oracle Application Express (Oracle APEX) APEX

Oracle has decided to invest further in this free tool.


With version 4.0 several new features see the light, but particularly the layout capabilities were significantly
improved.
 Error Handeling
 Websheets
 Dynamic Actions
 Ability to load Excel data

Especially the ability to use their own plugins ensured that Apex became very popular within certain
communities. (And of course because the tool is free)

When Oracle added "Team Development" Apex became really a development tool. Several people could
work simultaneously on the same application and the required reports were standard provided (reviews of
the comments, bugs, etc).

With version 4.2 Oracle ensured that users could use all the features of HTML 5.

With the integration of JQuery and JQuery Mobile, they also gave the developer the ability to create mobile
layout's.

Also the ability to make use of package applications was added in this version.
Oracle Application Express (Oracle APEX) APEX

And now we have Oracle Apex 5.x. Of course there are a lot of new features added in Oracle Apex 5.x.
 Pivot tabel (Interactive Report)
 Templates (Universal Theme)
 Calender Item
 Lay-out
 Mobile (Jquery mobile 1.4)
 Navigation List
 New icons (Font based)
 Modal pages

4- The complexity of the Oracle APEX


If your purpose is to build a Web application with Oracle database. A web system used for enterprises helps
managing personnel, wage and salary, and production, for example. A website focuses on creating a system
of forms of entering data, system of report, running 100% on the web base. Oracle APEX will be the good
Oracle Application Express (Oracle APEX) APEX

choice.

The easiness for programmers is shown in the following criteria:


You do not need a bulky and complicated IDE to programme:

If you programme Java, C# you need to install an IDE, for example, Eclipse, Netbeans, Visual Studio.
With Oracle APEX everything you do occurs on 1 website.

You do not need to know much knowledge of WEB


Oracle APEX is a system of building a Web application, forms of entering data on Web and reports running
on Web, but you may not need much knowledge about web.

Easily build a web interface


In order to have a form of entering data, you need not programme the interface in a complex manner.
Everything is provided in the form of an available pattern of Oracle APEX.

Easily build a reporting system


Oracle APEX provides you with a system of standard and friendly reporting tools.

No need to deploy client side


User can approach a application built from Oracle APEX through a web browser. You need not install
anything in user's computer.

As an Oracle APEX developer what you care about?


In order to develop an Oracle APEX application, you need to have knowledge about Oracle PL/SQL. This is
the most important thing in the process of developing your application on Oracle APEX. You work
with Oracle PL/SQL in most of the time..
Oracle Application Express (Oracle APEX) APEX

5- Some pictures of the applications developed by Oracle APEX


Oracle Application Express (Oracle APEX) APEX
Oracle Application Express (Oracle APEX) APEX
Oracle Application Express (Oracle APEX) APEX
Oracle Application Express (Oracle APEX) APEX
Oracle Application Express (Oracle APEX) APEX
Oracle Application Express (Oracle APEX) APEX
Oracle Application Express (Oracle APEX) APEX

You might also like