Oracle Data Redaction Oracle Advance Features Part I — Understanding Data Redaction 1.1  What Is Data Redaction? Oracle Data Redaction masks sensitive column values in a query’s result set at the …

Introduction – Oracle Database Blocking Sessions In Oracle Database, blocking occurs when one session holds a lock on a resource (typically a row or table) and another session attempts to …

Introduction Oracle APEX makes it possible to build interactive business applications using SQL and PL/SQL while also allowing developers to extend applications with JavaScript, CSS and AJAX-based processes. In this …

Oracle Flashback Database : A Practical Recovery Demonstration Introduction Oracle Flashback Database is a database recovery feature that allows a database to be rewound to an earlier point in time. …

Part I — Understanding Containerized Oracle Database 1.1  Why Run a Database in a Container A container turns “install Oracle Database” into “run this image,” which is most valuable exactly where …

Oracle ACE Associate ♠️ 2026 – Continuing the Journey Alhamdulillah. I’m honored to share that I’ve been promoted to Oracle ACE Associate ♠️ as of September 2, 2026 less than …

Part I — Understanding OCI Integration 1.1  Why an On-Premises Database Needs OCI at All A database does not have to run in the cloud to benefit from it. Shipping RMAN …

Part I — Understanding Data Guard & High Availability 1.1  What Is High Availability, and Where Data Guard Fits High availability is the discipline of keeping a database reachable through failures …

Part I — Understanding the Upgrade 1.1  Why Upgrade from 11g to 19c Oracle Database 11g exited extended support years ago, which means no new security patches, no new bug fixes, …

Part I — Understanding the Building Blocks 1.1  Procedures and Functions A stored procedure is a named block of PL/SQL, compiled and stored inside the database, that performs an action. A …