Posts

Blog 5 : Reports in Oracle APEX – Interactive vs Classic Explained

  Introduction Reports are one of the most commonly used components in Oracle APEX applications. They are used to display data from database tables or queries in a structured format. Oracle APEX mainly provides two types of reports: Classic Reports and Interactive Reports . In this blog, I explain the difference between Interactive Reports and Classic Reports , their features, use cases, and when to use each one. What is a Report in Oracle APEX? A report in Oracle APEX displays data retrieved from the Oracle Database using SQL queries. Reports help users: View data Analyze records Navigate between pages Perform actions like edit or delete Reports are essential for data-driven applications. Types of Reports in Oracle APEX Oracle APEX provides: Classic Report Interactive Report Each type has its own advantages and use cases. Classic Report in Oracle APEX A Classic Report is a simple and lightweight report that displays data in a fixed format. Featu...
Post a Comment
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...
Post a Comment
Read more

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 ...
Post a Comment
Read more

Blog 2: Oracle APEX Architecture

Image
  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: Web Browser (Client) Web Server 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 ...
Post a Comment
Read more

Blog 1: What is Oracle APEX

Image
  Introduction Oracle Application Express (Oracle APEX) is a powerful low-code web application development platform used to build secure, scalable, and data-driven applications. In this blog, I explain what Oracle APEX is , why low-code development is important , where Oracle APEX is used , and why I chose Oracle APEX as part of my learning journey. What is Oracle APEX?   Oracle APEX (Application Express) is a browser-based low-code development framework provided by Oracle. It enables developers to create web applications using SQL, PL/SQL , and built-in UI components with minimal front-end coding. Oracle APEX applications run directly on the Oracle Database , making it highly secure, fast, and reliable for enterprise applications. Key Features of Oracle APEX: Low-code development platform Built-in forms and reports Strong database integration Secure and scalable architecture No separate middleware required Why Low-Code Development? Low-code develo...
Post a Comment
Read more