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…
Business Intelligence in Oracle APEX
Why use Oracle? Because it has Oracle Application Express.
Oracle Application Express is good for fast applications and reports development
Quick development and deployment for simple apps!
Awesome APEX
Fast, cheap, and easy application development
Snap! The future is here
Oracle APEX, build with love
Exhilarating Trip to the Apex World
Be a Rock Star Developer with Oracle RAD Stack
Oracle APEX or Oracle Climax?
Oracle Application Express: the pinnacle of data driven software
The ideal tool for quickly creating web applications on an Oracle database.
APEX covers all - quick and efficient development and implementation
tennisapp.bfw-design.de (Oracle APEX 4.2/5.2/18.2)
BIB-Lueneburg APP (Oracle APEX-Mobile)
BIB-Lüneburg - Fairground Booking system (Oracle …
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
- Reusability (22)9.595%
- Platform User Management (22)9.494%
- Platform Security (22)9.090%
- Drag-and-drop Interfaces (22)7.979%
Reviewer Pros & Cons
Pricing
Oracle APEX Application Development
$0.32
Oracle Autonomous Transaction Processing - Exadata Storage
$118.40
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Demos
Application Express Demo
EBS-APEX - Demo EBS Extensions Using APEX Applications
Introduction to Oracle Application Express (APEX) Tutorial
Oracle Application Express
Pharmacy Online demo built in Oracle Application Express from http://dbswh.com
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.5Visual Modeling(21) Ratings
Visual modeling tooling allows business users to design processes visually.
- 7.9Drag-and-drop Interfaces(22) Ratings
Drag-and-drop interface for building applications
- 9Platform Security(22) Ratings
Security guardrails in place to help prevent malware, data breaches etc.
- 9.4Platform User Management(22) Ratings
Tools enabling admins to control user access and on-board and off-board users
- 9.5Reusability(22) Ratings
An internal repository where assets, modules, and even entire applications can be reused
- 9.4Platform Scalability(22) Ratings
Apps developed by low-code platform must be scalable and capable of supporting large numbers of users
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle APEX?
Oracle APEX Competitors
- PostgreSQL
- Microsoft
- Salesforce
Oracle APEX Technical Details
Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Unspecified |
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(105)Attribute Ratings
Reviews
(1-14 of 14)Best Low Code Application Development Platform
- Reporting
- Dashboards
- Various Data forms
- Quick applications
- Consuming REST Data Services
- Workflows - flexible one, with option to approvals by emails
- In-built connector for Microsoft Outlook 365 Cloud and world's most used emailing / Active Directory applications
Applications where reports and forms are there
Getting data from various sources like cloud
- Fast. Nothing beats Oracle Application Express in terms of speed of development. Almost all common and must-have features for most application has been built into Oracle Application Express, and we only need to focus to the specific requirements.
- Quality. Luckily, fast doesn't always translate to low quality. Even using basic wizard, within five minutes, we can build a quality application that has good security, a good user interface and good features, and this can be a very good standard for a company. It's not the best, but it's easy to tweak to achieve higher than standard quality.
- Customization. The apps created are very customizable. You only need to understand Oracle SQL and PL/SQL, Javascript, and JQuery. Then, you can create nearly any application you have in mind.
- Prototyping. When we are working for a client, sometimes it's hard to be on the same page when at first we only talk about the application concept. Using Oracle Application Express helps to create a prototype application and adjust it according to the client's input within minutes. This greatly helps bringing IT and non-IT clients on the same page faster.
- It's tied up to Oracle Database only. If you don't have Oracle Database, forget Oracle Application Express.
- I wish it has offline mode so it could be used in no-internet areas and sync it when it's back online.
- It's not critical, but it would be nice if there were more choices of themes. I know Oracle Application Express has couple of themes, but in my opinion, currently only Universal Theme is the theme for Oracle Application Express.
Other than that, avoid Oracle Application Express (e.g., apps which rely heavily to Javascript functionality, apps to analyze Twitter data, apps which need to manipulate OS files, apps to create complex and static reports).
Snap! The future is here
- Manages security well
- Provides a responsive environment to build apps in
- Easy connection to database services
- Manages sessions very well
- Javascript functionality
- Mobile app development- more versatility required especially with the display of reports
- More documentation that is easy to understand
- More sample apps on configuration of services and authentication schemes
- Make it easy to customize templates
- More themes required
Be a Rock Star Developer with Oracle RAD Stack
- Oracle Application Express is tightly integrated with and thus leverages all the richness and power of the Oracle database - best RDBMS on the planet
- Promotes declarative Rapid Application Development and thus provides tremendous business value by shortening development cycles
- Can't think of any - the Application Express development team does a fantastic job adopting and supporting emerging trends with each new release.
- Requires Oracle RDBMS; i.e., is not portable to other RDBMS platforms. On the surface this may seem like a con but it is as it should be - Oracle database is best RDBMS available and tight integration with Oracle RDBMS promotes creation of reliable performant apps.
- Easy upgrade path from Forms, allowing reuse of code and a low learning curve for Forms developers.
- Very quick to develop in. Ideal for prototyping or iterative development which is how we usually work.
- Comes with cross browser and mobile compatibility out of the box.
- Easy to incorporate other web technologies.
- Development environment runs straight from a browser. This has proved to be a life saver when issues crop up on a weekend.
- No built in printing solution for reports.
- While being low code for many tasks, some web development skill is helpful for anything complex. I frequently need to use Javascript/CSS/HTML.
For less standardized tasks, the architecture will allow the use of other web technologies. I have, for instance, incorporated Google Maps into Oracle Application Express in order to visually show data, such as the operating areas, for our consultants. Setting this up in the Application Express framework is relatively straightforward allowing me to concentrate on the heavy lifting in PL/SQL.
The only major area I've found that it isn't well suited in currently is outputting anything printable, typically requiring the use of some 3rd party hardware or Oracle BI (if money is no object). I have also run into issues when working with larger teams as it doesn't lend itself well to source control with all the pages being stored in the database itself.
tennisapp.bfw-design.de (Oracle APEX 4.2/5.2/18.2)
BIB-Lueneburg APP (Oracle APEX-Mobile)
BIB-Lüneburg - Fairground Booking system (Oracle APEX)
ESFA - Clubmember Administration and Bookkeeping (Oracle APEX 5.2/18.2)
Facility Management with Financial Acconting (Oracle APEX 18.2)
KIS - Kundeninformationssystem (CRM + ERP + Controlling + HR) für Gutachterbüro - 200+ Mitarbeiter (Oracle APEX 5.2/18.2)
Module: Enter Order (ERP), Sales (CRM), Controlling, Management/Reports, Training Planing, Complaint Management,
Vacation/Absence Administration with approval process and calendar visualisation
73 Tables, 309 pages, Accounting: hostet (cloud) application
In production sind August 2017 - daily entering of about 900-1000 orders by 200 employees, daily settlement.
Printing (PDF) based on Jasper-Reports.
Construction Company: Working hours collection/monitoring with Tablet/Smartphone inkcl. Interface to DATEV und external Salary calculation provider (Oracle APEX 18.2)
- Ideal for quick prototyping
- Ideal for quick amendments and enlargements
- Numerous types of pages/regions (forms, lists, reports, diagrams)
- Oracle JET integration
- REST
- Optional Jasper Reports integration (not OOTB)
- Printing in good shape not so easy.
- Diagrams, charts need more detailed explanation concerning the SQL queries needed (examples).
- No more cons.
ERP, CRM, HCM, Financials, mobile apps.
The business problems are totally diverse, ranging from HR, CRM, ERP, mobile apps and portals.
APEX is mostly used in an environment where an Oracle database is already present -- that could be for developing in-house applications, or hosting Oracle's own ERP systems like Oracle E-Business Suite or any other Fusion product. APEX is the tool of choice if you want to build extensions or customizations to these standard applications.
And APEX is by design "cloud ready" -- it always has been and will always be.
- Fast development due to the low code approach.
- Responsive out of the box due to the built-in Universal Theme.
- Cloud enabled by design. You can build applications only using a web browser.
- Scalable: if it runs inside the Oracle database, it uses the full power of that database.
- Free: it is a no-cost option for the Oracle database.
- It runs everywhere where Oracle runs, from a small (free) XE database on your laptop, to an Exadata machine.
- The only languages you need to know are SQL and PL/SQL. Some JavaScript and CSS knowledge might be handy but not strictly necessary.
- Version control. As all metadata is stored in the database, there are no files to store in a GIT or Subversion repository (unless you export from the database).
- Lock in: you are locked in into the Oracle database, and that's why it is mostly used in an environment where that database is already present.
- Oracle is not "popular" at the moment, so the average developer is somewhat older than the regular (JavaScript) developer.
Oracle Express
- Eliminates the complexity involved with multi-faceted web applications.
- Oracle Express supports enhanced productivity in low code apps.
- It requires no complex build scripts to operate.
- The software supports effortless customization and design.
- Lack of a native app.
- Installation time can be improved, it takes a while to download.
Oracle APEX: A quick tool for building responsive Web pages
- Oracle APEX can be used as good replacement for Excel data entry sheets.
- It provides high level of security about their personal information.
- It is very easy to install.
- As it is Oracle-specific, it is not suitable for other databases.
- Everything is stored online, if there is no internet we can't access the tool.
APEX: A versatile development platform, ideal for developing or improving applications at low cost
- It is an easy tool to adopt, which allowed us to replace developments in Oracle Forms in many cases.
- It is very simple to develop different kinds of analysis, in a faster and more friendly way than running Oracle Reports.
- It helped us to extend our approval workflow, in order to cope with difficult branches that were hard to solve with the standard workflow.
- It was possible to develop web applications, to share information and transactions with our commercial partners.
- Perhaps is our problem, since we haven’t explored it deeply, but I think that a better portability to mobile devices would help the adoption of APEX.
- Applications weren’t as light as we thought, and we had to move the APEX server to the same data center where our data base was running, due to performance issues. When we started, we supposed that that situation would not be an issue.
- At least in Argentina and Brazil, you can not find as many programmers with experience in APEX as you can find with other technologies.
Building apps with APEX
- It's all web-based. Very easy to get started.
- Lots of tutorials and books available on the topic
- Easy to build useful apps
- Security is both simple and strong
- Just need a web browser to use the app
- It is not a batch processing environment. Not sure this is 'room for improvement' but it is best at collecting and displaying information, getting information from spreadsheets, form entry, and more.
- If the web is not available, you cannot access the app.
- No connection to the server' and manually editing anything. it is all online and stored in Oracle tables.
Best tool to build web application
- Easy to build web-based application as we need to write less code.
- It provides an attractive user interface to build database queries.
- It provides high-level security which means never worry about their personal info.
- It should increase the perfomance as we face performance issues while using dynamic files.
- It should return instant results so that resubmiting a page can be avoided.
- There are many steps required to find out the actual issue in the code.
- APEX can help you create complex and powerful reports and drill downs along with the ability to Edit the data on the fly.
- APEX can be a good replacement for Excel data entry sheets, providing centralized access to table data with authentication.
- Data entry forms with validations and triggers can be created using your existing Oracle infrastructure, easy to implement and deploy.
- APEX is a tool that can combine data entry forms and reporting (parent/ child ) using the Oracle tables in your database.
- Users get the ability to make changes to the forms data in Apex and commit, get to the report page and see the changes in real time.
- For complex APEX applications you need to be a pro expert in PL/SQL
- Debugging in APEX can be complicated if there is a logical error. Syntax errors will end up shown as ORA errors
- Lack of designer interface. Even though you are designing a form you need to do it by means of APEX interface using a series of steps, no UI for design
- Oracle specific not applicable for other databases
Oracle Application Express (ApEx) Analysis
Thanks to its versatility, ApEx is able to solve many kinds of business problems, like - small reporting, through the implementations of simple and navigable reports; - database writing, through many kinds of forms; - web-service (Oracle and non) invocations; - creating charts and data based diagrams. ApEx is a really flexible tool that can interact with many different technologies, has a lot of plugins and is fully accessible from a browser, both from a desktop platform and from mobile.
- Installation included for free with Oracle Database
- Easy to access from a browser, both from desktop and from mobile
- Simple web based interface for development
- Easy to learn, with a good variety of functionalities already implemented and customizable
- Able to interact with Oracle back-end technologies and with many third parties web tools
- Sometimes it is so simple that it doesn't offer the desired functionality
- At the beginning it may be a bit difficult to work with the customizations required starting from the basic applications offered inside the installation
- It may be difficult to insert "advanced" customizations on the page (eg: web scripting for effects or popups)