Noor Bappy - Oracle Specialist | Apex Expert

How to Set ORDS 22.1 Configuration Path on Linux for Apache Tomcat When deploying Oracle REST Data Services (ORDS) 22.1 on Apache Tomcat in Linux, a common issue is the dreaded: 404 Not Found The request could not be mapped to any database This…

Oracle APEX — Shared Components FULL LIST 1️ - Application Logic (Core Backend) Controls global behavior of the app Application Definition Application Items Application Processes Application Computations Application Settings Build Options 👉 Purpose:…

Create bat file : set ORACLE_HOME=c:\DevSuiteHome_1 set PATH=%ORACLE_HOME%\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jlib;%ORACLE_HOME%\jdk\bin c:\DEVSUITEHOME_1\BIN\rwserver server=repsrvr autosta…

Download link 1st :  https://drive.google.com/drive/folders/18nqBVHoTOnU6VwKCg-WnetgsL6f1Qx4Y rwservlet.properties : SERVER_IN_PROCESS=YES RELOAD_KEYMAP=YES #DIAGNOSTIC=YES #TRACEOPTS=TRACE_ALL #TRACEFILE=rwservlet.trc #TRACEMODE=TRACE_REPLACE SERVER=…

If you’ve worked with Oracle Forms , you know how convenient the Enter key is for moving between fields or directly to action buttons like Save or Update . In Oracle APEX , this behavior doesn’t exist by default—but with a little JavaScript , we ca…

Group Left Report : declare   V_COMPANY_NAME VARCHAR2(100):='ABC COMPANY.';   cnt number(10):=0;   vGross number(11,2):=0;   vRowIndex NUMBER := 1; begin   htp.p('   <a id="b_exit" type="button1" class="button …

HOW TO CONNECT ORACLE 6i FORMS TO ORACLE 12c / 19c Pre-requisites Disable Case-Sensitive Passwords Developer 6i cannot handle case-sensitive logins introduced in 11g+. ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE; (Now passwords are treated as u…

How to Install Oracle Database 19c in Oracle Linux 7.9 vi /etc/hosts 192.168.100.9  ol7-19.localdomain  ol7-19 vi /etc/hostname ol7-19.localdomain yum install -y oracle-database-preinstall-19c yum update -y passwd oracle vi /etc/selinux/config SELINU…

E:\ords>"C:\Program Files\Java\jdk-15.0.1\bin\java" -jar ords.war install   Enter a number to select the type of installation     [1] Install or upgrade ORDS in the database only     [2] Create or update a database pool and install/upgra…

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…