Noor Bappy - Oracle Specialist | Apex Expert

Setting up Oracle REST Data Services (ORDS) with Apache Tomcat is a crucial step if you want to run Oracle APEX in a modern web environment. This guide walks you through a clean installation, configuration, and deployment process on Oracle Linux. 🔧 S…

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…

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 …

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…

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 …

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 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…

ORACLE DATABASE 19C ON OEL8.8    [root@apex]# hostname apex.testdb.com [root@apex]# su oracle  [oracle@apex ~]$ cd /home/oracle/ [oracle@apex ~]$ mkdir -p soft [oracle@apex ~]$ cd soft/ [oracle@apex soft]$ ls -lrt total 0 [oracle@apex soft]$ pwd /home…