Sabarinath A

  🚀 Introduction In today’s digital applications, user verification plays a crucial role in ensuring security and trust. Traditionally, OTPs are sent via SMS — but with the widespread use of WhatsApp, sending OTPs through WhatsApp offers: Faster delivery Better user reach Improved engagement In this blog, we explore how to implement OTP verification in Oracle APEX by integrating WhatsApp messaging using an external API service. 🎯 Objective The goal of this implementation was to: ✔️ Generate OTP dynamically ✔️ Send OTP via WhatsApp ✔️ Integrate external messaging API ✔️ Enhance login/verification security ✔️ Enable real-time communication 🧩 Solution Overview This solution integrates: PL/SQL OTP generation REST API call from Oracle APEX WhatsApp messaging service This allows Oracle APEX applications to send OTP directly to users via WhatsApp instead of SMS.  🧱 Step-by-Step Approach  Step 1: Configure WhatsApp API To send OTP via WhatsApp, ...

  🚀 Introduction In modern enterprise applications such as Learning Management Systems (LMS), onboarding portals, and compliance training platforms, tracking how much of a video a user has watched is extremely important. Instead of simply marking content as viewed, organizations often need to: Monitor viewing progress Ensure full completion Resume playback from last watched position Prevent users from skipping content To address this requirement, I developed a Video Tracking Mechanism in Oracle APEX integrated with SharePoint-hosted videos that captures real-time watch progress and stores it in the database. This solution enhances user experience while enabling accurate engagement tracking. 🎯 Objective The goal of this implementation was to: ✔️ Track video watch percentage ✔️ Display real-time progress ✔️ Resume playback automatically ✔️ Mark videos as fully watched ✔️ Maintain user-wise tracking ✔️ Stream videos directly from SharePoint ✔️ Support mul...

  🧾 Introduction  In modern enterprise applications, improving usability plays a key role in increasing productivity. Oracle APEX Interactive Grids are widely used for displaying and managing structured data, but small enhancements can make a big difference in user interaction. One such enhancement is enabling users to quickly copy column values with a single click. Instead of manually selecting text, this feature allows seamless copying directly from the grid, saving time and improving efficiency. In this article, we will explore how to implement a smart click-to-copy functionality within an Interactive Grid in Oracle APEX using simple JavaScript and minimal configuration. 🎯 Objective The goal of this enhancement is to: Simplify data copying from Interactive Grid cells Reduce manual effort for end users Improve overall user experience Provide instant visual feedback after copying ⚙️ Implementation Overview To achieve this functionality, we will: Identify ...