Skip to main content
TrustRadius
Oracle APEX

Oracle APEX

Overview

What is Oracle APEX?

Oracle APEX (or Oracle Application Express) is an online low-code application builder that allows users to develop a database-drive application, customize the application's UI, and then give their users access to the application via URL. Oracle APEX includes a suite…

Read more
Recent Reviews

Awesome APEX

10 out of 10
October 23, 2019
Incentivized
APEX is being used by our Financial department as well as HR supporting a variety of applications. It is a wonderful tool supporting a …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 6 features
  • Reusability (22)
    9.7
    97%
  • Platform User Management (22)
    9.5
    95%
  • Platform Security (22)
    9.3
    93%
  • Drag-and-drop Interfaces (22)
    8.1
    81%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing

Oracle APEX Application Development

$0.32

Cloud
OCPU per hour

Oracle Autonomous Transaction Processing - Exadata Storage

$118.40

Cloud
Terabyte storage capacity per month

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://apex.oracle.com/en/learn/gettin…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Demos

Application Express Demo

YouTube

EBS-APEX - Demo EBS Extensions Using APEX Applications

YouTube

Introduction to Oracle Application Express (APEX) Tutorial

YouTube

Oracle Application Express

YouTube

Pharmacy Online demo built in Oracle Application Express from http://dbswh.com

YouTube
Return to navigation

Features

Low-Code Development

Low-code development tools allow non developers to build simple process applications with little oversight. These tools simplify the application building process, and are frequently used for simple process applications.

9.3
Avg 8.7
Return to navigation

Product Details

What is Oracle APEX?

Oracle APEX (or Oracle Application Express) is an online low-code application builder that allows users to develop a database-drive application, customize the application's UI, and then give their users access to the application via URL. Oracle APEX includes a suite of pre-built productivity applications and examples, such as a Survey Builder, Bug Tracking, P-Track project management, etc

Oracle APEX Competitors

Oracle APEX Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Oracle APEX (or Oracle Application Express) is an online low-code application builder that allows users to develop a database-drive application, customize the application's UI, and then give their users access to the application via URL. Oracle APEX includes a suite of pre-built productivity applications and examples, such as a Survey Builder, Bug Tracking, P-Track project management, etc

PostgreSQL are common alternatives for Oracle APEX.

Reviewers rate Reusability highest, with a score of 9.7.

The most common users of Oracle APEX are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(105)

Attribute Ratings

Reviews

(1-2 of 2)
Companies can't remove reviews or game the system. Here's why
Lisandro Fernigrini | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Right now I created a small app to track pending/ongoing tasks using APEX on the newly available Oracle Cloud Free Tier. I decided to create it to simplify how I manage and execute my daily tasks in order to be able to both track advance and manage dependencies between tasks. I use Trello to keep boards with simple tasks but managing dependencies was something not simple to achieve, so I decided to try a solution that solved my problems while starting to use APEX.
  • The UI is very easy to use, and you can choose from a number of templates for each "screen" you design.
  • You can design basic CRUD screens without knowing the "details" (technology) under the hood.
  • It's easy to test. Just one click, and the page you are working on is executed.
  • Deployment on an OnPremise DB is not so simple. You need to follow many steps (that's why I used the Cloud version!).
I would definitively use APEX for small (department size) applications that can be developed and maintained by a small development team, without a complex design/develop/test/deploy process.
Also, to generate all basic CRUD on complex applications, rather than programming them using other languages (Java. c#, etc) and having more complex deployment processes.
Low-Code Development (6)
83.33333333333334%
8.3
Visual Modeling
70%
7.0
Drag-and-drop Interfaces
80%
8.0
Platform Security
90%
9.0
Platform User Management
90%
9.0
Reusability
70%
7.0
Platform Scalability
100%
10.0
  • I am currently using it myself, since some of the tasks and activities I perform daily were hard to follow up using my company tools. I did not perform an ROI analysis since I developed it in my free time just to simplify my daily work, but I'm really happy with the results I obtained in a few days of development.
I did not evaluate any other Rapid Application Development tool. I wanted a quick and simple solution just for my personal use so I directly tried using APEX since I work with Oracle databases and have a good background on the SQL and PL/SQL languages. I am currently replacing a couple of Trello boards where I used to follow up the task, since I can now manage tasks dependencies.
1
I developed a small app to track tasks, I'm currently using it myself
Currently we do not have in-house support. The application was developed and deployed on Oracle Cloud Free Tier so all admin task are automated and handled directly by Oracle Cloud. I developed some new features / enhancements and also fixed a bug once I discovered it, but the business rules of the app are really simply and no additional work is foreseen.
  • Follow up tasks with multiple dependencies
  • I plan to add other devops staff as users
  • Replace traditional CRUD pages developed using C# with CRUD pages hosted on APEX for our Oracle based modules.
I felt very comfortable using Oracle Application Express from the start. I designed my data model and quickly developed the basic CRUD pages for master tables. Then I designed the main functionality and was able to test and deploy it in a couple of days work. I will probably share the app with other members of the team and continue adding some features in the short term.
No
  • Price
  • Product Features
  • Product Usability
Since it is a free to use product, that can be deployed to any existing Oracle Database (or use it on the cloud) I decided to use it to create a small app that help me track daily tasks. It may be later moved to a database hosted in any company server if we decide to use the app with other company employees.
No, I would not change the evaluation / selection process. It was a "direct" one, since I was looking for a free product that could be deployed locally (my own PC, hosting an Oracle XE database instance), on a company (on-premise) server or even on the cloud, and APEX clearly fitted into this criteria.
Using it on the cloud is really simple, the entire process of configuring and provisioning an Oracle Database takes only a few minutes (less than 10) and then Oracle APEX is already deployed on the database, so you just have to start using it. I would strongly recommend using APEX on Oracle Cloud Free Tier.
  • Implemented in-house
No
Change management was minimal
Since I'm the only user of current app, and I'm using it as a test to improve the way I can track some complex task status, change management was not required since we still did not change the current company process. In the future if we decide to integrate this with existing task management software it may require adapting the process and the app.
  • To use it locally (on my own PC) it requires a DB instance (I already have an Oracle XE database for prototyping / testing) but the deployment process was not easy, having to decide between different ways to install that require different actions. I preferred to use the CLOUD version of the product that does not require any install / deploy.
I did not required support from Oracle, I used to community forums to get some details on specific things I wanted to do and was able to find what I was looking for.
Not Available
No
Fortunately, I did not have the need to ask for support with Oracle.
It was really simple for me, with a strong background on DB programming (SQL, PL/SQL, T-SQL) but almost no User Interface or frontend experience to design, develop and deploy in few days a simple but efficient application.
Most of the pages I designed required no technical knowledge on the database nor SQL or PL/SQL languages.
  • Page Templates
  • None
Yes, but I don't use it
Kathryn Gamble | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Its used for business information reporting and for application development. Its used across the whole organization and was adopted to provide a fast flexible solution for information reporting. It has replaced paper-based and spreadsheet-based checking of business data on a regular daily basis. Its also being used to replace 3rd party software - for example a complaints management system.
  • Enables fast application development and can be used by all levels of developer from novice to advanced
  • Produces good looking, intuitive responsive web applications that are easy for the end user to understand and use
  • It's in the database so can leverage all the power and functionality already there in Oracle.
  • Improvements are being made all the time. Some more documentation of javascript APIs is in the next release - this will be useful
  • Increased range of charts and diagrams would be good but it is already possible to do these using Oracle Jet with a bit of effort using javascript.
Well suited to data entry and reporting. great for replacing small departmental spreadsheet applications in very quick time - up and running in minutes but I've also been involved in large-scale projects with thousands of users so scalability isn't a problem. One of the best things is that users love using Apex applications - I was told today by a user that it doesn't feel like working when she uses my applications.
  • Its made working processes more efficient - and it is a free product so investment is purely in terms of staff resource costs. As its so easy to use and so fast, return on this is fast
  • Been able to terminate contracts with 3rd party suppliers - hundreds to thousands of £ per month - by replacing with Apex applications
I have advanced oracle skills and so for me its the obvious choice. Its free of charge and does everything I need. No need to lok at alternatives in this situation. Everything else would be costly or require third party integration. I have also used oracle apex against other databases (sqlserver) to good effect
100
All business functions from branch staff to upper management. Accountants, business development managers, marketing staff, customer service representatives, IT team members, management information team, business analysts. Its used across the business for reporting, for data entry for data validation and as a tool to save time in various day to day tasks.
3
To support the data functions of Apex, a knowledge of SQL language is pretty much essential and knowledge of how the database is structured - the data model etc - is useful. For general IT support, understanding the web application is needed in order to make sure the web server part of Apex is running and functioning - the skills for this depend on your choice of web server - Apache/Glassfish/Tomcat etc. A DBA would be needed to roll out changes into a production environment and to run the (very simple) installation scripts. General support (password resets etc.) depends on how you have set up authentication for teh applications - LDAP, database account etc. In most cases I build a support application which performs the necessary admin/support /monitoring functions and can be used by a helpdesk person without any deep technical knowledge of the Apex application or the database. After that, supposrt would be done by a database support ember because the applications are all part of the databse.
  • Data reporting
  • Checking and validation of data including audit trail to show that data has been checked and results of checks stored in the database
  • A complaints system
  • I use an apex application to automatically build other apex applications
  • I use apex to help with training end users how to use apex
  • Monitoring user activity
  • Provides a departmental Wiki
  • More reporting with end user input and customisation
  • Replace endless spreadsheet "applications" which are endemic in the business with better, more controlled applications that allow proper multi user access.
  • Automate admin tasks (for DBAs and database support team)
You don't have to renew it. If you have an Oracle database (even the free XE version) you have Apex. Its so easy to use it would be daft not to.
No
  • Price
  • Product Features
  • Product Usability
  • Product Reputation
  • Prior Experience with the Product
  • Vendor Reputation
You don't have to purchase the product. It is already part of the database. I was hired by my present company as they had decided that they would like to use Apex and I had the relevant experience to get them up and running. Their decision was made on price (its free) and reputation (its great) as well as the basic skills required are already there as part of the database team.
Its a no-brainer. There are other products that do similar things but they cost and are not integrated into the database. Users and developers actually ENJOY using APex applications and developing them. Why would you want to change that?
  • Implemented in-house
Yes
Install on development/test system, develop and test then roll out small applications - enhance these applications in future releases.
Change management was a small part of the implementation and was well-handled
Its as simple as you want it to be. All changes fit into existing change management procedures - same as any code run in live environment.

  • None
Its as simple as running a SQL script in the database. No existing applications are affected
Very active and knowledgeable community support includes quick and helpful responses from the Oracle employees on the product development team. I've never had to raise an official support request - everything is dealt with via forums and user groups - or via direct emails. The supposrt commuinty is one of the great things about Apex.
No
I have not had to use Oracle support for Apex. Any problems or questions I have are answered either by contacting the product development team - meet them at conferences or via the support forums. I have been given excellent advice and given my own feedback in person. I also get teh feeling that the experience of users is taken on board when they are developing new releases. There is always a beta version of the next release to try out and feed back on.
  • creating interactive reports
  • building responsive web pages
  • data validations
  • modification of css
No
its easy to use as a developer and applications designed using apex are easy and intuitive to use as an end user. Even non-coders can build good applications, the more code you can write the more you can enhance the application but you can get up and running quickly with almost no technical know how.
Return to navigation