Make no mistake: there are many fast development tools available to create web applications but there are significant differences between them. When we think about the most important aspects of application development tools we realize that often times they are not built into rigid and expensive, commercial off-the-shelf (COTS) solutions. In this article we will introduce Oracle Application Express (APEX) in high-level and highlight a few out-of-the box features that Oracle APEX offers for rapid, modern, and dynamic application development.
The 2-Tier Architecture of Oracle APEX is pretty simple. It allows for maximum efficiency and performance by eliminating unnecessary tiers, and connecting the web layer directly to the database layer. The web layer can be configured in many different ways, but the preferred configuration is: Oracle REST Data Services (ORDS) running a Java server, such as: Oracle Web-Logic, Oracle Glassfish, or Tomcat.
Oracle APEX is tightly integrated to the Oracle database; it actually lives in the database. When users navigate through their Oracle APEX application’s components, the underlying URL requests are translated into plain PL/SQL calls by the web server. All application’s definitions are stored as metadata in the Oracle database. The heavy lifting and data processing is fully performed in the database engine, taking full advantage of Oracle’s robust and scalable database engine. Results are then relayed back to the browser in HTML format.
Oracle APEX offers several out-of-the-box components such as:
Interactive reports are end-user customizable powerful reports. Users can interactively show/hide certain columns, add filters, breaks, computations, highlights, aggregations, sorting, create charts and pivot reports, and export to different formats such as CSV, HTML and PDF.
Interactive grids offer a modern and interactive multi-row editing functionality allowing users to directly manipulate data represented in any cell by simply clicking on the cell. They also offer the same reporting functionality in interactive reports.
Oracle APEX offers customizable calendars that can imbed data from database tables, along with drag and drop capabilities that make them very powerful in visualization and scheduling.
Web Service Integration
Oracle APEX supports various forms of web service integration, allowing Oracle APEX to either consume external web services, or publish its own web services that can be consumed by other systems.
Want to discuss how CEI’s Oracle APEX Practice can benefit your organization?
Reach out to Joe Esposito, Sr. Account Executive, at firstname.lastname@example.org or 412.680.4880. Be sure to subscribe to our blog or follow us on social media to stay on top of our latest Oracle APEX and application development insights, special events, and more.