Latest Posts

  • πŸš€ Building a Generative AI Chatbot with RAG in Oracle APEX (Step-by-Step Guide)
    Artificial Intelligence is transforming how users interact with applications. With Generative AI + RAG (Retrieval-Augmented Generation), you can build smart chatbots that not only generate responses but also fetch accurate data from your database. In this blog, I’ll walk you through how to build a ChatGPT-like AI Assistant inside Oracle APEX using Cohere + RAG Sources. πŸ” What We Are Building A chatbot inside Oracle APEX that can answer questions like:…
  • πŸš€ Implementing β€œShow More” Button in Interactive Grid in Oracle APEX
    Interactive Grid is one of the most powerful components in Oracle APEX, widely used for displaying and managing large datasets. By default, Interactive Grid uses pagination, which can sometimes impact user experienceβ€”especially when users prefer scrolling instead of switching pages. In this blog, we’ll learn how to replace traditional pagination with a β€œShow More” (Load More) button, allowing users to load data dynamically. 🎯 What You Will Achieve After implementing this…
  • πŸš€ Ensuring Data Accuracy with SQL Assertions in Oracle AI Database 26ai
    Introduction AI systems depend entirely on data quality. Even the most advanced models fail when the underlying data is inconsistent or incorrect. Ensuring data accuracy is not just important β€” it is essential for building reliable AI applications. The Problem These approaches fail when dealing with multi-table relationships, leading to inconsistent and unreliable data. The Solution: SQL Assertions SQL Assertions in Oracle AI Database 26ai introduce a powerful way to enforce…
  • πŸš€ Building an AI-Powered Database Application (No SQL Required)
    What if users could query your Oracle database in English or any language β€” without writing SQL? I built an AI-powered application using Oracle APEX that transforms natural language into SQL and instantly delivers insights as charts, KPIs, and reports. This is how modern data interaction should feel. 🚫The Problem Most business users cannot write SQL. This leads to: Limited access to data for non-technical users Data exists β€” but access…
  • πŸš€ Implementing a Clear Icon Button in Popup LOV Using APEX Shortcuts
    In many Oracle APEX applications, Popup LOV items are used to allow users to search and select values easily. However, sometimes users need additional flexibility such as: In one of our recent projects, the client requested the following functionality: βœ” A Clear (X) icon button next to the Popup LOV βœ” Ability to manually enter text βœ” Automatically convert input to uppercase In this article, we will learn how to implement…
  • πŸš€ How to Define Environment Banner in Oracle APEX (DEV, TEST, PROD) – Step-by-Step Guide
    When working with multiple Oracle APEX environments such as Development, Test, and Production, it is very easy for developers or users to accidentally perform actions in the wrong environment. For example: To avoid these issues, Oracle APEX provides a simple but powerful feature called Environment Banner. This banner visually displays the environment name at the top of the application so users immediately know where they are working. In this guide, we…
  • 🎨 Enhancing Popup LOV in Oracle APEX with Custom Templates
    One of the most powerful and user-friendly item types in Oracle APEX is the Popup LOV (List of Values). Developers love it because it provides a clean UI, and users love it because it supports powerful search capabilities across multiple columns (introduced in APEX 19.2). Popup LOV supports: βœ… Single value selection βœ… Multiple value selection βœ… Inline popup display βœ… Modal dialog display βœ… Multi-column search capability By default: But…
  • πŸ” Ultimate Guide to Oracle APEX Metadata Views
    (Complete Developer Reference with Sample Queries) Oracle APEX stores everything as metadata. Every page, region, item, process, automation, REST source, workflow, theme β€” all of it lives inside database views. These views start with: Understanding them makes you: πŸ— 1️⃣ Workspace & Instance Views These operate at the workspace level. πŸ”Ή APEX_WORKSPACES Available Oracle APEX workspaces. πŸ”Ή APEX_WORKSPACE_APEX_USERS Workspace users. πŸ”Ή APEX_WORKSPACE_SESSIONS Active APEX sessions. πŸ”Ή APEX_WORKSPACE_ACTIVITY_LOG Page view activity. πŸ“¦…
  • 🧩 How to Create a Kanban Board in Oracle APEX Using Material Kanban Board Plugin
    Kanban boards are one of the most powerful ways to manage tasks visually. In this blog, I’ll walk you step-by-step through building a fully dynamic Project Task Kanban Board in Oracle APEX using the Material Kanban Board Plugin, including: 🎯 Final Output Your Kanban board will look like this: πŸ—„οΈ Step 1: Database Tables Below is a simplified structure used for this implementation. πŸ“Œ PROJECTS Table Column Name Data Type Description…
  • Invalid Numeric Value in Oracle APEX? The Hidden Comma Problem in URL Parameters Explained
    A Real-World Lesson on Passing Page Items Safely in Oracle APEX πŸ” The Issue Faced in Production Recently, I have faced a critical production error while navigating from a report page (Page 29) to an Edit page (Page 31). Users were clicking the Edit icon, and suddenly this error appeared: Invalid numeric value King for column EMPNO ORA-06502: PL/SQL numeric or value error: character to number conversion error It was working…
  • Using Collections in Oracle APEX with Real Scenarios
    Introduction Oracle APEX Collections are temporary, in-memory data structures that live inside a user session. They are extremely powerful when you need to store, manipulate, and use data without immediately committing it to database tables. Think of Collections as session-based tables that: In this blog, we’ll explore real-world scenarios, step-by-step usage, and where Collections fit best. What is an APEX Collection? An APEX Collection is: πŸ“Œ Best Use Case: Temporary data…
  • πŸ”’ Interactive Grid: Lock / Unlock Rows in Oracle APEX
    Introduction This document explains how to implement a Lock / Unlock functionality in an Oracle APEX Interactive Grid. A common real-world scenario is when you create an Interactive Grid for the HR department to update employee information such as: However, not all records should be editable. For example: These records should not be modified accidentally. They must remain unchanged, while other records should continue to be available for updates. To achieve…
  • APEX URL Structure and Session Management Explained
    Introduction Every Oracle APEX developer has seen URLs like this: But very few truly understand: In this blog, we’ll break down APEX URL structure and session management in simple words, using real-world examples and easy-to-understand diagrams. What is an APEX URL? An APEX URL is the entry point to an Oracle APEX application. It tells APEX: Basic format: Breakdown of APEX URL Parameters 1️⃣ Application ID (App) Example: πŸ“Œ Every APEX…
  • Performance Tuning Tips for Large Oracle APEX Applications
    When Oracle APEX applications growβ€”more users, more data, more pagesβ€”performance becomes critical. A slow APEX app frustrates users and gives the impression of poor design, even when functionality is correct. This step-by-step guide covers practical, real-world performance tuning techniques you can apply to large Oracle APEX applications used in production. Step 1: Understand Where the Time Is Going Before tuning anything, you must identify the bottleneck. What to Check Tools to…
  • Using REST APIs in Oracle APEX (Consume & Expose)
    Introduction In real-world applications, Oracle APEX rarely works in isolation. Modern applications need to talk to other systemsβ€”fetch data from external services or expose their own data for mobile apps, third‑party tools, or integrations. This is where REST APIs come in. In this blog, we’ll understand: All explained with real-time, practical examples in simple words. What is a REST API? A REST API (Representational State Transfer) allows applications to communicate over…
  • πŸ—οΈ Oracle APEX Architecture Explained in Simple Words (Step-by-Step)
    1. Introduction Oracle APEX (Application Express) is often described as a low-code web application development platform, but many developersβ€”especially beginnersβ€”feel confused when they hear terms like ORDS, Web Listener, Database, Browser, and PL/SQL engine. In this blog, we’ll break down Oracle APEX architecture in very simple words, step by step, and understand what happens when a user clicks a button in an APEX application. No heavy theoryβ€”just clear concepts you can…
  • πŸ”„ AJAX Callback Process in Oracle APEX
    1. Introduction Modern web applications are expected to be fast, responsive, and interactive. Users do not want full page refreshes for small actions like validating data, fetching values, or performing calculations. Oracle APEX supports this requirement through AJAX Callback Processes, which allow communication between the client (browser) and server (database) without submitting or reloading the page. An AJAX Callback Process enables you to execute PL/SQL code asynchronously from JavaScript and return…
  • πŸ’Ό Building an Employee Expense Reimbursement Workflow in Oracle APEX
    Managing employee expense reimbursements is a classic business use case β€” and a perfect fit for Oracle APEX Workflows. In this blog, we’ll build a real-world, end-to-end Expense Reimbursement Workflow where small expenses are auto-approved and larger ones require manager approval. By the end of this guide, you’ll have: Let’s dive in πŸš€ 🧩 Workflow Scenario Business Rules: πŸ”§ Part 1: Prerequisites – Database Setup Before creating the workflow, we need…
  • πŸ“₯πŸ“Š Download Multiple Excel Reports Using Application Processes in Oracle APEX
    In real-world Oracle APEX applications, there are scenarios where users need to download multiple reports at onceβ€”for example, a detailed transactional report along with a master reference report. Oracle APEX does not provide a built-in feature to download multiple files in a single click. However, by combining Application Processes, PL/SQL, and JavaScript, we can implement a clean and effective solution. This blog demonstrates how to: Solution Overview We will create: Step…
  • πŸ“Œ Oracle APEX Limits You Should Know (Component-Wise Guide)
    Introduction Oracle APEX is a powerful low-code platform that allows developers to build scalable enterprise applications rapidly. While APEX offers a rich set of features, every component comes with certain limits that developers should be aware of to avoid unexpected issues during development or production. In this blog, we’ll walk through important Oracle APEX component limits, covering reports, forms, data loading, validations, exports, and more. Understanding these limits early helps in…
  • πŸ” Embed Another Oracle APEX Application Page Using URL Region (Seamless UX)
    1. Introduction In Oracle APEX applications, delivering a seamless and consistent user experience across multiple applications is often a key requirementβ€”especially when those applications live within the same workspace. In this blog post, I’ll share a practical approach to embedding a page from one Oracle APEX application into another, without users even realizing they’re switching applications. The navigation menu remains the same, there’s no second login prompt, and the experience feels…
  • πŸŽ‰ Enhancing Oracle APEX Interactive Grid with HTML Expression & Inline Popup
    Oracle APEX Interactive Grid (IG) is extremely powerful, but sometimes we need richer user interactions without relying on third-party plug-insβ€”especially in restricted enterprise environments. In this article, we’ll explore how to use HTML Expression, Inline Popup, and Template Directives together to display contextual information directly from an Interactive Grid. This approach allows users to view detailed employee and department information via action buttons, all while keeping the grid clean and user-friendly.…
  • 🚫 Disable Double Click on Submit Button in Oracle APEX
    Introduction In Oracle APEX applications, a very common real‑world issue is users clicking the Submit button multiple times. This can lead to duplicate records, multiple workflow triggers, or unexpected errors, especially when the page process takes a few seconds to complete. To ensure data integrity and provide a better user experience, it’s important to disable double‑click or multiple submissions on buttons. In this blog, we’ll explore simple and effective ways to…
  • πŸ” Setting Up GitHub Sign-In Authentication in Oracle APEX
    1. Introduction Oracle APEX provides built-in support for OAuth 2.0 authentication, making it easy to integrate external identity providers like GitHub. By configuring a GitHub OAuth application and linking it with APEX authentication schemes, users can log in using their GitHub accounts seamlessly. This blog demonstrates a step-by-step setup for enabling GitHub Sign-In in Oracle APEX. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3.…
  • πŸ” Set Focus on Search field in Interactive Report in Oracle APEX
    1. Introduction In Oracle APEX applications, user experience (UX) plays a vital role in improving productivity and usability. One common requirement is to automatically place focus on the Search field of an Interactive Report after refreshing the report. This article explains a simple and effective approach to set focus on the Search field (column search) in an Interactive Report using Dynamic Actions and JavaScript. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business…
  • πŸ“„ Preview Image & PDF Without Submit in Oracle APEX
    1. Introduction In many Oracle APEX applications, users upload images or PDF documents and expect an instant preview before saving the record. However, by default, APEX processes file uploads only after a page submit, which can impact user experience.  In this blog, we’ll see how to preview image and PDF files instantly without submitting the page, using Dynamic Actions and JavaScript in Oracle APEX. 2. Tools and Technologies To achieve the desired…
  • πŸ” Setting Up Google Sign-In Authentication in Oracle APEX
    1. Introduction Modern applications demand secure and user-friendly authentication methods. Google Sign-In simplifies the login process by allowing users to authenticate using their existing Google accounts. In this blog, we’ll walk through the step-by-step process of configuring Google OAuth and integrating it with Oracle APEX. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement Organizations often require a secure, reliable, and user-friendly authentication…
  • πŸ“ˆ How to Calculate Dynamic Column Totals from an Editable Interactive Grid in Oracle APEX
    1. Introduction Oracle APEX Interactive Grid is a powerful component that allows users to view and edit data directly within the page. However, in many real-world applications, users expect instant feedback when they modify numeric valuesβ€”such as automatically updating totals or summaries on the same page. By default, Interactive Grids do not provide a built-in way to dynamically calculate and display column totals outside the grid. In this blog, we will explore how…
  • ✏️ How to Enable Interactive Grid Edit Mode Automatically on Page Load
    1. Introduction This article explains How to Enable Interactive Grid Edit Mode Automatically on Page Load. The solution is implemented using a combination of Oracle APEX and Javascript. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement In many business applications, users primarily interact with data in edit mode to perform frequent updates, data entry, or corrections. Requiring users to manually switch the Interactive Grid to…
  • βž•πŸŽ― Add Row with Auto Focus on specific Column in Interactive Grid in Oracle APEX
    1. Introduction This article explains How to Add Row with Auto Focus on specific Column in Interactive Grid. The solution is implemented using a combination of Oracle APEX and Javascript. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement The business requires an enhanced data entry experience in the Oracle APEX Interactive Grid to improve user productivity and accuracy. When users add a new row, the…
  • πŸ“Š Oracle APEX Interactive Grid Cheat Sheet – JavaScript & CSS Shortcodes
    Introduction Interactive Grid (IG) in Oracle APEX is powerful, but mastering a few reusable JavaScript and CSS snippets can significantly improve productivity and user experience. Below are short, practical IG shortcuts that you can quickly plug into your applications. 1. Disable Column Reorder & Resize Prevent users from rearranging or resizing grid columns. πŸ“ Where to use: Interactive Grid β†’ Advanced β†’ JavaScript Initialization Code 2. Hide the Save Button Hide the Save button when changes…
  • πŸ”„ Add Horizontal Scrollbar on Top of Interactive Grid in Oracle APEX
    1. Introduction This article explains How to Add Horizontal Scrollbar on Top of Interactive Grid in Oracle APEX. The solution is implemented using a combination of Oracle APEX and CSS. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement Users frequently work with wide datasets in Oracle APEX Interactive Grids that contain many columns. By default, the horizontal scrollbar appears only at the bottom of the grid, forcing users to…
  • 🎯 How to Hide Interactive Grid Toolbar Buttons in Oracle APEX (Step-by-Step Guide)
    1. Introduction This article explains How to Hide Interactive Grid Toolbar Buttons in Oracle APEX. The solution is implemented using a combination of Oracle APEX and Javascript. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement To improve usability, security, and data governance, the application must restrict end users from accessing unnecessary or unauthorized actions in the Oracle APEX Interactive Grid. Certain toolbar buttons (such as…
  • 🧩 How to Capture Column data from Interactive Grids into Page Items in Oracle APEX
    1. Introduction This article explains How to Capture Column data from Interactive Grids into Page Items in Oracle APEX. The solution is implemented using a combination of Oracle APEX, PLSQL and Javascript. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement The application must allow users to select one or more rows from an Oracle APEX Interactive Grid and automatically capture the corresponding EMP NO(s) into…
  • πŸ‘‰ Copy to Clipboard in Oracle APEX: A Step-by-Step Guide
    1. Introduction This article explains How to create Copy to Clipboard in Oracle APEX. The solution is implemented using a combination of Oracle APEX, Javascript and CSS. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement Business users frequently need to copy key information such as IDs, reference numbers, URLs, email addresses, report values, or Code snippet from Oracle APEX applications to share with other teams…
  • πŸ“Š Improving Reports Readability in Oracle APEX with No-Wrap Columns
    1. Introduction This article explains How to Improve Reports Readability in Oracle APEX with No-Wrap Columns. The solution is implemented using a combination of Oracle APEX and CSS. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement Business users frequently rely on Oracle APEX reports to review and analyze operational and transactional data. Many of these reports contain a large number of columns, causing important fields…
  • πŸš€ The Ultimate Guide: Setting Up Oracle XE + APEX + ORDS + Tomcat on Windows
    Welcome to OracleAPEXHub! If you are looking to build a robust, production-ready development environment without breaking the bank, you have come to the right place. In this guide, I will walk you through a complete “Full Stack” installation. We are combining the lightweight power of Oracle Database XE with the low-code magic of APEX, served professionally via ORDS and Apache Tomcat. Whether you are building an HRMS, a blog, or a complex enterprise app, this foundation is exactly…
  • 🧾 Generating Barcodes in Oracle APEX Using APEX_BARCODE
    1. Introduction This article explains How to Generating Barcodes in Oracle APEX Using APEX_BARCODE. The solution is implemented using a combination of Oracle APEX, PL/SQL and CSS. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement Many business applications require barcode generation to support daily operational needs such as inventory management, asset tracking, invoicing, shipping, and document identification. Traditionally, implementing barcode functionality in Oracle APEX applications involved using third-party libraries,…
  • βž• Create a Floating Action Button (FAB) in Oracle APEX
    1. Introduction This article explains How to Create a Floating Action Button (FAB) in Oracle APEX. The solution is implemented using a combination of Oracle APEX and CSS. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement Users frequently perform key actions such as Create, Add, Upload, or Submit within Oracle APEX applications. Currently, these actions are placed within page buttons or regions that may require scrolling, especially on…
  • ⏱️ Display Report Execution Time Using #TIMING# in Oracle APEX
    1. Introduction This article explains How to Enable Image Upload Inside the Display Report Execution Time Using #TIMING# in Oracle APEX. The solution is implemented using a combination of Oracle APEX. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement Users frequently access data-heavy reports within the Oracle APEX application. As data volume grows, report loading time becomes a key factor affecting user experience,…
  • πŸ–ΌοΈ How to Enable Image Upload Inside the Rich Text Editor in Oracle APEX
    1. Introduction This article explains How to Enable Image Upload Inside the Rich Text Editor in Oracle APEX. The solution is implemented using a combination of Oracle APEX and JavaScript. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement Users currently use the Rich Text Editor (RTE) in Oracle APEX to create formatted content, but they cannot insert or upload images directly. This limitation affects documentation…
  • πŸŒ™β˜€οΈ Implement Light Dark & Auto Theme Mode in Oracle APEX
    1. Introduction This article explains how to Implement Dark, Light & Auto Theme Mode in Oracle APEX. The solution is implemented using a combination of Oracle APEX, SQL  and PL/SQL. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement Users should be able to switch between Light Mode, Dark Mode, or Automatic Mode (based on system preference) using a simple toggle/button on the screen. The selected mode should be saved as…
  • 🧩 How to Create a Footer in Oracle APEX – Step by Step Guide
    1. Introduction In many web applications, the footer is an essential element that helps with branding, navigation, and providing important information like contact details, copyright, terms & conditions, or quick links. In Oracle APEX, there is no direct region type called β€œFooter”, so we need to design it using static regions + HTML + CSS, and make sure it stays at the bottom of every page. 2. Tools and Technologies To achieve the…
  • πŸ”„ Dynamic Reports in Oracle APEX: Display Table Data Based on Select List Selection
    1. Introduction This article explains how to Fetch & Display Table Data Dynamically from Dropdown in Oracle APEX. The solution is implemented using a combination of SQL/PL/SQL and Oracle APEX. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement The organization needs a flexible reporting feature in Oracle APEX where users can select any table from the application database and instantly view its data in report format β€” without creating individual reports for…
  • πŸ” Return to the Same Page and Row in an Interactive Grid After Navigating Back in Oracle APEX
    1. Overview This post explains how to automatically return to the same row and page in an Interactive Grid (IG) after navigating away and coming back to the report. The solution ensures that the user’s position and selected record remain intact, enhancing the overall user experience. This functionality is achieved using JavaScript and Oracle APEX page items. 2. Technologies and Tools Used To implement this feature, the following tools and technologies are used: 3. Use Case In many…
  • βš™οΈ Configure OKTA Single Sing-On Authentication in Oracle APEX
    1. Introduction This article explains how to setup OKTA Single Sing-On Authentication in Oracle APEX. The solution is implemented using a combination of OKTA, SQL/PL/SQL and Oracle APEX. Okta Single Sign-On (SSO) is a cloud-based identity management solution that enables users to access multiple applications and services using a single set of login credentials. It offers a centralized platform for managing authentication and access control, streamlining the user experience while improving overall security. 2. Tools…
  • 🧱 How to Hide Interactive Grid Report Toolbar Buttons in Oracle APEX
    1. Introduction Oracle APEX Interactive Grids (IGs) are powerful components that allow developers to display, edit, and manage data efficiently. While the default toolbar offers a wide range of features β€” such as editing, saving, and adding rows β€” there are scenarios where you may want to hide specific toolbar buttons without losing other functionalities. In this post, we’ll explore why you might want to hide toolbar buttons like Edit, Save, or Add Row, and how to implement it effectively using…
  • πŸ‘₯ Collaborative Development using Application Working Copies
    1. Introduction Starting with Oracle APEX 23.2, you can create a Working Copy of an application to fix a bug, add a feature and then selectively merge your changes back into the Main application. Similarly, you can also refresh changes from the Main application into the Working Copy. During the merge or refresh process, you can view a comparison (or diff) of the Working Copy and the Main application and then…
  • ⌨️ Custom Navigation from Page Item to Interactive Grid Column on Tab Press in Oracle APEX
    1. Overview This article explains how to implement custom navigation in Oracle APEX, where pressing the Tab key moves focus directly from a page item to a specific column in an Interactive Grid (IG). Why do we need this? In certain scenarios, a user may need to enter a mandatory value in a page item and then skip intermediate fields, jumping directly to a particular Interactive Grid column. By customizing navigation, we can streamline data entry and…
  • πŸ”Ž Focus on the First Editable Page Item in Oracle APEX
    1. Introduction This article explains how to automatically set the focus on the first editable page item when a page loads in Oracle APEX. The solution is implemented using a combination of SQL/PL/SQL and JavaScript. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement In many applications, users expect the cursor to automatically focus on the first editable item when a page opens. This small enhancement improves user…
  • πŸ“Š Download APEX Chart as Image Using JavaScript
    1. Overview In this post, you’ll learn how to download a chart created in Oracle APEX as an image file using JavaScript. You might wonder β€” why would I need to download a chart as an image?A common use case is when you want to share the chart via email or include it in a document. Converting the chart to an image makes it easy to distribute outside of APEX. 2. Tools & Technologies…
  • ⚠️ Prevent Duplicate Tabs to open in Oracle APEX Using JavaScript
    1. Introduction This article explains how to automatically set the focus on the Prevent Duplicate Tabs to open in Oracle APEX Using JavaScript when a page loads in Oracle APEX. The solution is implemented using a combination of HTML and JavaScript. 2. Tools and Technologies To achieve the desired functionality, the following technologies are used: 3. Business Requirement Allowing multiple instances of the same page to run at once can create several challenges, such as: 4.…
  • πŸ” Verify Users from LDAP Directory in Oracle APEX
    1. Introduction This guide explains how to verify whether a user exists in an LDAP directory using Oracle APEX and PL/SQL. In some scenarios, you may need to check if a user account is present in the LDAP directory before allowing access or performing specific actions. This document outlines the steps to implement such verification. 2. Technologies Used 3. Why This Is Needed In many enterprise applications, user authentication and validation are managed through LDAP. Before…
A close-up view of a book page displaying structured code written in a programming language, likely Java. The text is oriented diagonally, capturing sections of code including a method definition and exception handling.
A promotional webpage highlighting Glide Pages, showing a browser displaying the message about transforming data into beautiful web apps and websites. The background features a gradient from blue to red, and there's a web interface preview with user profiles displayed as circular images.

Our Services

Helping you master Oracle APEX with tutorials, insights, and real-time solutions.

A laptop on a wooden desk displays a web application interface featuring graphs and statistics. Beside it, a large monitor shows a webpage promoting an all-in-one meeting app. A cup with a recognizable green and white logo sits on the desk.
An iPad displaying data visualization content next to a book titled 'Data Science for Business.' The iPad is showing notes and a diagram about dashboard design, accompanied by a stylus placed between the iPad and the book.

Join Us

Stay updated with fresh Oracle APEX tips, tutorials, and job leads every week.

Subscribe