#1 most frequent
United States of America
53.0%1,938 installations of 3,659
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
Categories & Use Cases
Product Demos
Top Performing Features
Reusability
An internal repository where assets, modules, and even entire applications can be reused
Category average: 8.7
Platform Security
Security guardrails in place to help prevent malware, data breaches etc.
Category average: 8.5
Platform User Management
Tools enabling admins to control user access and on-board and off-board users
Category average: 8.3
Areas for Improvement
Platform Scalability
Apps developed by low-code platform must be scalable and capable of supporting large numbers of users
Category average: 8.5
Drag-and-drop Interfaces
Drag-and-drop interface for building applications
Category average: 8.5
Visual Modeling
Visual modeling tooling allows business users to design processes visually.
Category average: 7.6
Who Buys & Uses Oracle APEX
#2 most frequent
India
5.4%198 installations of 3,659
#3 most frequent
Germany
5.1%188 installations of 3,659
Best Low Code platform for Rapid Application Development in Oracle world
Use Cases and Deployment Scope
Our organization uses Oracle APEX for below scenarios: Custom Application Development:
We use Oracle APEX to create custom web applications tailored to specific business needs. These include HR (Human Resources) management systems as well as Financial applications. Oracle APEX’s low-code environment enables rapid application development without extensive coding expertise, reducing the time required to deliver functional applications. Data Visualization and Reporting: Oracle APEX is being used for building interactive reports and dashboards that provide actionable insights. It allows developers to create graphs, charts, and tables, making it easier for business users to understand and analyze data.
Business users are able to visualize business KPIs and other important metrics without needing external tools.
Pros
- Data Visualization and Reporting
- Process Automation and Workflows
- Rapid Application Development with Low Code approach
- Integration with Existing Systems
- Strong AI Capabilities
Cons
- IDCS based Developer accounts
- Integration with Fusion Cloud
Return on Investment
- Rapid application development and deployment
- Less development costs due to low code approach
- Scalable and flexible
Usability
Alternatives Considered
Oracle Visual Builder Cloud
Other Software Used
Oracle Visual Builder Cloud, Oracle Fusion Cloud ERP, Oracle Integration (OIC), Oracle Data Integrator (ODI), Oracle Autonomous Data Warehouse
Why use Oracle? Because it has Oracle Application Express.
Use Cases and Deployment Scope
At first, Oracle Application Express was used by only one department. However, after realizing the benefit, gradually it has been adopted by the whole organization. Majority of the use case is for Internal Application, with user mostly from employee. Example of Internal Application such as small-scale ERP, workflow framework, tracking assets and licenses, issue tracking system, and also can be used to analyze and monitor various data, such as activity log and sales dashboard. To use Oracle APEX for commercial application is not recommended, unless you have very good Oracle DBA.
Pros
- 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 business 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. The default is basic, but it's easy to tweak to achieve higher than standard quality. Notable features are checksum to enable integrity of web application, interactive report, interactive grid, modular ajax functionality, instrumentation for every user and developer action, PWA ready.
- Customization. The apps created are very customizable. You only need to understand Oracle SQL and PL/SQL, Javascript, CSS3, 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.
Cons
- 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.
Return on Investment
- Due to our limited IT resources (mostly because we are not IT company), easy, fast, and sustainable framework allows us to catch up with business improvement without hiring additional IT resources.
- Prototyping done quickly and easily also improve our application quality. We are able to map business requirements to application more accurately, ensuring sustainability and less maintenance for go-live application. This also saves the need for huge IT resources.
- Because we already use Oracle Database, and our existing IT members are all proficient in Oracle SQL and PL/SQL, there are only a few learning curves to adopt Oracle Application Express the first time.
- Because it's too easy and quick, it has downside. We can have tendency to be lazy to adopt other modern and more flexible language.
- For the business requirement that still changing, this tool is perfect. Any change request will require little effort and can be developed quick.
- The negative is, if sometimes in future the user of application reaches very big, then we need to rewrite entire application using another technology stack since oracle apex can only scale vertically.
Usability
Alternatives Considered
Appsmith
Other Software Used
Qlik Sense, Microsoft Visual Studio Code, UiPath Automation Platform, Microsoft Teams, Snowflake, OneNote, DBeaver
Oracle Apex - Pros and Cons
Use Cases and Deployment Scope
We are using Oracle Apex for internal development like creating forms or automation of medium complex processes. It is a Power app so provide us both Web app and mobile app features. We are also creating reports in it with good visualization features. But it becomes difficult to develop the program in it, when the process is too mouch complex.
Pros
- Creating forms for collecting data from users.
- Automating manual process to systems
- creating mobile app for existing process.
Cons
- It is not fully customizable for a developer
- It becomes to develop complex programs in it
- The infra of Oracle apex in high in cost.
Return on Investment
- License cost of Apex is high.
- Infra required for Oracle apex is also high
- It creates power app which is compatible on both browser and mobile application
Usability
Alternatives Considered
Liferay Digital Experience Platform (DXP) and OutSystems
Other Software Used
Microsoft Visual Studio, Oracle SQL Developer, Node.js
Best Low Code Application Development Platform
Use Cases and Deployment Scope
My Organization used Oracle Application Express for many custom applications, few are open on Internet. These applications cover areas like ERP security, ERP related complex reports, Dashboards, Manufacturing related, etc. Our apps are integrated with ERP, Cloud based CRMs, many licensing applications, etc.
Pros
- Reporting
- Dashboards
- Various Data forms
- Quick applications
- Consuming REST Data Services
Cons
- 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
Return on Investment
- Low development cycle
- Rich interface
- Quick turnaround time
- Support latest web technologies
- Great community support
Alternatives Considered
Microsoft Power Automate and ServiceNow App Engine
Other Software Used
Oracle E-Business Suite, Oracle Identity Management, Oracle SOA Suite
Be a Rock Star Developer with Oracle RAD Stack
Pros
- 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
Cons
- 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.
Return on Investment
- There have been numerous cases where solution development using Oracle's "RAD Stack" (ORDS, RDBMS & APEX) has saved many ten's of thousands of dollars in cost that would have otherwise been incurred by following vendor recommendation and/or other alternatives.
- Impact on overall business objectives has been completely positive: low cost of maintenance, seamless easy upgrades, reduced development time
Other Software Used
Visual Studio IDE, Oracle SQL Developer
