In reporting and analytics, we often need to rotate data — turning rows into columns or columns into rows.SQL provides two powerful operators for this purpose: PIVOT and UNPIVOT. Let’s explore them step by step with examples from the HR schema. Example 1: Pivoting Employee Count by Job and Department This query counts employees by […]
In the journey toward resilient, high-availability database systems, Oracle continually evolves. With Oracle 19c, Data Guard gains a set of refined features that strengthen standby operations, simplify recovery, and improve manageability. In this post, we’ll explore the key new Data Guard features introduced in Oracle 19c and their operational impact. 1. Automatic Flashback of Standby […]
In the high-stakes world of database reliability, disaster recovery must be validated before it’s ever needed. With Oracle 19c’s Fast-Start Failover (FSFO) feature, you gain powerful automation for failover scenarios under Data Guard. But how do you test failover logic without impacting your production setup? The answer lies in Observe-Only Mode, and that is the […]
In Oracle 19c, enhancements in the Data Guard Broker enable DBAs to set, reset, and display database initialization parameters directly through the broker interface. These commands allow parameter changes to take effect immediately on the active database (or standby, or Far Sync) without first editing the broker configuration file. This article explains these new commands, […]