Part I — Understanding Database Health Checks 1.1  What Is a Database Health Check? A database health check is a structured review of an Oracle Database instance and its supporting infrastructure, …

Part I — Understanding Oracle APEX 1.1  What Is Oracle APEX? Oracle Application Express (APEX) is a low-code development platform built into every Oracle Database. It lets you design, build, and …

Part I — Understanding Oracle REST Data Services 1.1  What Is ORDS? Oracle REST Data Services (ORDS) is Oracle’s Java-based middle tier that lets applications and external clients access Oracle Database …

Part I — Understanding RMAN 1.1  What Is RMAN? Recovery Manager (RMAN) is Oracle’s built-in utility for backing up, restoring, and recovering Oracle databases. It ships with every installation of the …

Part I — Understanding Hire to Retire (H2R) 1.1  What Is H2R? Hire to Retire (H2R) is the standard ERP/HCM name for the complete employee lifecycle process from the moment a …

In most Oracle APEX applications, static SQL is enough for reports, LOVs, validations, and database operations. But sometimes the SQL statement itself needs to change based on user input or …

Oracle APEX makes it possible to build applications with little code, but when an application needs business logic, database processing, validations, or complex operations, PL/SQL becomes an essential part of …

Oracle VirtualBox for Windows Windows Server Guest VM Part I — Understanding This Approach 1.1  Why Build a Windows Server Guest VM? The ORDS and APEX guides in this series are …

The Oracle Forms Journey (From Version 5.0 to Forms 14c) Three Decades of Architecture, Survival, and Modernization Part I — The Client/Server Era A note on the screens below — …