Creating a Hierarchical Video Lessons Viewer in Oracle APEX ✅ Embedded video playback ✅ Rich HTML content ✅ Click-to-load interaction Step 1: Create the LESSONS Table CREATE TABLE "LESSONS" ( "LESSON_ID" NUMBER , "T…
To prevent the same user from logging in multiple times simultaneously in Oracle APEX, you can implement session management using a custom login process and a session tracking table. Here’s how to do it step by step: Step 1: Create a Session Tracking …
When building applications in Oracle APEX, you often want to let users print a specific region on the page — for example, a report or invoice — with just a click of a button. But sometimes, the print dialog opens in a new tab or window, disrupting the…
Oracle APEX makes it easy to build interactive web applications — even without being a full-time developer. One of the simplest yet most powerful features is controlling the visibility of buttons based on certain conditions. Let’s walk through how y…
In Oracle APEX, you can create interactive classic reports that allow users to select a record and pass its values into a page item, without refreshing the whole page . One common case is setting an item like :P5_ID When a user clicks on a value (lik…
In this post I will describe some Reports that are frequently required by management and authority. The following reports are frequently required by the management and Authority:- ESSENTIAL REPORT(s) : 1 - 2nd, 3rd, 4th etc. lapse ratio by number pol…
In oracle Apex when you want to delete from a collection : Item Name : P101_DELETE_ID In Link add the code : javascript:getID(&SEQ_ID.) Link Text : <span class="fa fa-trash-o"></span> Add the function at "Function and G…
Sometimes we may want to convert digits in English to Bengali or a Different Language. We might use the following function to convert - CREATE OR REPLACE FUNCTION F_Bdigits(input_value IN NUMBER) RETURN VARCHAR2 IS bengali_digits CONSTANT VARCHAR2(5…
We found Tables of Following along with Data. Created the Tables : CREATE TABLE "COUNTRY" ( "COUNTRY_ID" VARCHAR2(3), "COUNTRY_NAME" VARCHAR2(100), CONSTRAINT "PK_COUNTRY" PRIMARY KEY ("COUNT…
A bug in Oracle Apex Date : It shows like this : 2008 to 2028 You can control how many entries are in the selection list for the year selection, by setting in custom attributes the following: year-selection-range="100" like this :