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:
- The PL/SQL Gateway
- The PL/SQL Web Toolkit
- Continue reading