Item: Oracle APEX
Rating: 9
Author: Prasanta Panda

Overall Satisfaction with Oracle APEX

Use Cases and Deployment Scope

Oracle APEX is our main UI and reporting tool and it is used across the whole organisation. It provides day to day activity tracking and monitoring, providing SLA reporting to top management. Integrated with other internal and external systems using REST services.

Pros and Cons

Pros

Tightly integrated with the database which help developer to use same knowledge of SQL and PL/SQL to develop the full stack application.
Easy to learn and using low-code we can develop application in no time.

Cons

Improvement on screen layout, specifically designing dashboard with drag and change position and save by user.
Report with sub-reports as drill-down report configuration.
Security across application.
Oracle should develop some plugin and maintain it, like displaying images, start and end date validation plugin, separate time component plugin.
More functionality in IG and standard reports.

Return on Investment

Easy to prototype for new projects.
No additional cost for front end development.
No additional group of developers required as DB developers can use to develop the front end as well.