Monthly Archives: October 2012

Explained: How does APEX work?

This might be one of the most common questions when introducing APEX to someone used to a totally different web stack. Or, as I’ve witnessed it many times, to a beginner or intermediate APEX developer who was to focused on building apps, but not really trying to understand how APEX really works. Here’s an explanation:

PL/SQL Web Applications

What are those? Well, a web application written in PL/SQL is a set of subprograms that interact with web browsers through HTTP. APEX itself and the applications it produces is exactly that: PL/SQL code that interacts with the web server of choice, whether EPG, Apex Listener or Oracle HTTP server.

In order to develop and execute a PL/SQL web application, you need to use two components: