RMRob Moayedzadehinblog.dbadispatch.tech·2d ago · 7 min readMigrating Oracle LOBs from BasicFile to SecureFiles: A Field GuideNotes from a real production migration on Oracle Standard Edition 2, ahead of a 12c → 19c upgrade. BasicFile is Oracle's original LOB storage mechanism, predating 11g. SecureFiles has been the default00
RMRob Moayedzadehinblog.dbadispatch.tech·2d ago · 5 min readCloning a Pluggable Database (PDB) Across CDBs via Database LinkApplies to: Oracle Database 19c (Standard/Enterprise Edition), multitenant architecture Status: Draft / Verified in test Overview This runbook documents cloning a source PDB into a new target PDB usi00
SJSushama Jangleinoracleapexsessionstate.hashnode.dev·2d ago · 7 min readOne Application, Multiple User Experiences: Building a Role-Based Authorization Framework in Oracle APEX👋 Introduction When I started building one of my Oracle APEX applications, my initial focus was straightforward: create the pages, connect the database, and make sure every feature worked correctly. 00
SJSushama Jangleinoracleapexsessionstate.hashnode.dev·4d ago · 4 min readBuilding an Enterprise Email Framework in Oracle APEXReusable Templates || Dynamic Placeholders || Professional Notifications How I built a reusable HTML email framework in Oracle APEX that sends professional business emails using dynamic placeholders i00
SJSushama Jangleinoracleapexsessionstate.hashnode.dev·5d ago · 4 min readViewing PDF Files in Oracle APEX: Creating a Seamless Document Experience for Business UsersIntroduction As Oracle APEX developers, we often build applications that manage business-critical information—employee records, invoices, purchase orders, customer requests, audit reports, and much mo00
RKRavi Kumar Yadavingenerate-absolute-urls-in-oracle-apex.hashnode.dev·5d ago · 5 min readMastering Advanced Interactive Grid Customizations in Oracle APEX with JavaScript & PL/SQLOracle APEX Interactive Grids (IG) provide out-of-the-box reporting and editing capabilities. However, enterprise applications frequently require advanced user interactions—such as conditional cell ed00
RKRavi Kumar Yadavingenerate-absolute-urls-in-oracle-apex.hashnode.dev·6d ago · 4 min readEnterprise REST APIs in Oracle Database: Building High-Performance JSON Services with ORDS & PL/SQLExecutive Summary As modern enterprise architectures shift toward decoupled microservices and reactive front-end frameworks, expose-and-consume patterns inside Oracle Database are essential. Oracle RE00
MSManu Shuklainecorpit.hashnode.dev·Aug 2 · 10 min readOracle's July 2026 Critical Patch Update: how to triage 1,400+ fixes by trust boundaryOracle's July 2026 Critical Patch Update: how to triage 1,400+ fixes by trust boundary Summary. Oracle's July 2026 Critical Patch Update, released on 21 July 2026, is its largest ever: more than 1,40000
SJSushama Jangleinoracleapexsessionstate.hashnode.dev·Aug 1 · 6 min readOracle APEX Error to Solution: The Debugging Playbook Every Developer Should Know📖 Introduction Last month I spent almost an hour looking at a page process because I was convinced the PL/SQL was wrong. The real issue turned out to be a NULL page item in Session State. Since then,00
UAUptime Architectinuptimearchitect.hashnode.dev·Aug 1 · 13 min readThe Oracle Hardening Checklist That Actually MattersOpen any Oracle security benchmark and you'll find two hundred–plus line items, each with a rationale, a check, and a remediation. It is thorough, it is auditable, and it is where most hardening proje00