Blog 2: Oracle APEX Architecture

 

Oracle APEX Architecture Explained for Beginners

Introduction

Oracle APEX Architecture explains how different components work together to build and run a web application. Understanding this architecture is very important for beginners because it helps us know where our code runs, how data flows, and why APEX is fast and secure.

What is Oracle APEX Architecture?

Oracle APEX follows a three-tier architecture, where all components are tightly integrated with the Oracle Database. Unlike traditional applications, Oracle APEX does not require a separate application server.

The architecture mainly consists of:

  1. Web Browser (Client)

  2. Web Server

  3. Oracle Database (APEX Engine)



1️⃣ Web Browser (Client Layer)

This is where the user interacts with the application.

  • Runs on browsers like Chrome, Edge, or Firefox

  • Displays pages, forms, and reports

  • Sends requests when users click buttons or submit forms

📌 Example: Login page, report page, form page

2️⃣ Web Server

The web server acts as a middle layer between the browser and the database.

  • Receives HTTP requests from the browser

  • Forwards requests to Oracle Database

  • Sends responses back to the browser

Common web servers:

  • Oracle REST Data Services (ORDS)

  • Apache / Tomcat (used internally by ORDS)

📌 ORDS is the most commonly used server with Oracle APEX.

3️⃣ Oracle Database (APEX Engine)

This is the core of Oracle APEX.

  • APEX is fully stored inside the Oracle Database

  • SQL and PL/SQL logic is executed here

  • Handles security, session state, and validations

  • Generates HTML pages dynamically

📌 This tight integration makes Oracle APEX highly secure and fast.

How Oracle APEX Works (Request Flow)

  1. User opens an APEX application in the browser

  2. Request is sent to the web server (ORDS)

  3. ORDS forwards request to Oracle Database

  4. APEX engine processes SQL/PLSQL

  5. HTML page is generated

  6. Response is sent back to the browser

Why Oracle APEX Architecture is Powerful

  • No separate application server required

  • High performance due to database integration

  • Strong security model

  • Easy scalability

  • Ideal for enterprise applications

Conclusion

Oracle APEX architecture is simple yet powerful. By understanding how the browser, web server, and database work together, beginners can build efficient applications with confidence. This knowledge helps in debugging issues and designing better applications.

Comments

Post a Comment

Popular posts from this blog

Blog 3: Creating My First Oracle APEX Application – Step by Step

Image
  Introduction Creating your first application in Oracle APEX is an exciting step for beginners. Oracle APEX makes application development easy using its low-code features while still allowing strong control over database logic. In this blog, I explain how to create your first Oracle APEX application step by step , based on my learning experience. This guide is ideal for beginners who are starting their journey with Oracle APEX. Prerequisites Before creating an Oracle APEX application, you should have: Access to an Oracle APEX workspace Basic knowledge of SQL A web browser (Chrome, Edge, or Firefox) How to request a free workspace to start developing web applications in oracle apex Step 1: Login to Oracle APEX Workspace Open Oracle APEX URL (apex.oracle.com or company workspace) Enter: Workspace Username Password Click Sign In 📌 After login, you will see the Oracle APEX Builder Home Page . Step 2: Create a New Application Click App Builder ...
Read more

Blog 4: Forms in Oracle APEX – Insert, Update, and Delete Explained

  Introduction Forms are one of the most important components in Oracle APEX applications. They allow users to insert, update, and delete data directly in the Oracle Database. In this blog, I explain how forms work in Oracle APEX, how CRUD operations are handled, and common issues faced by beginners. This guide is written based on my Oracle APEX learning experience. What is a Form in Oracle APEX? A form in Oracle APEX is a page that displays database table data using page items . Each page item is mapped to a table column. Oracle APEX automatically handles database operations using built-in processes. Forms help developers perform: Insert (Create) Update Delete operations easily. Types of Forms in Oracle APEX Oracle APEX provides different types of forms: Form on a Table Form on a View Form on a SQL Query Master-Detail Form For beginners, Form on a Table is the easiest to start with. Creating a Form in Oracle APEX (Step-by-Step) Step 1: Create F...
Read more