apps-dba journal

A working journal for Oracle DBAs.

March 27, 2026

Oracle SQL Implicit Conversion and ROWNUM Explained

Oracle SQL Implicit Conversion and ROWNUM Explained Oracle SQL: Implicit Conversion and ROWNUM Explained Oracle SQL is very flexi...

Read the full lesson

March 27, 2026

Oracle SQL Relational Database Concepts: Tables, Keys and Relationships

Oracle SQL: Relational Database Concepts Explained Oracle SQL: Relational Database Concepts Explained Relational databases are th...

Read the full lesson

March 27, 2026

Oracle SQL MERGE Statement and Advanced DML Patterns

Oracle SQL MERGE Statement and Advanced DML Patterns Oracle SQL MERGE Statement and Advanced DML Patterns MERGE solves the common...

Read the full lesson

March 27, 2026

Oracle SQL Advanced Subqueries: Scalar, WITH Clause and DML Subqueries

Oracle SQL Advanced Subqueries: Scalar, WITH Clause and DML Subqueries Oracle SQL Advanced Subqueries: Scalar, WITH Clause and DML ...

Read the full lesson

March 27, 2026

Oracle SQL SELECT Fundamentals: Columns, Aliases, DISTINCT and Expressions

Oracle SQL SELECT Statement Fundamentals: Complete Guide Oracle SQL SELECT Statement Fundamentals: Complete Guide The SELECT sta...

Read the full lesson

March 27, 2026

Oracle SQL Data Dictionary Views: USER_, ALL_ and DBA_

Oracle SQL Data Dictionary Views: Complete Guide Oracle SQL Data Dictionary Views: Complete Guide The data dictionary is Oracle’s...

Read the full lesson

March 27, 2026

Oracle SQL ALTER TABLE: Adding, Modifying and Dropping Columns and Constraints

Oracle SQL ALTER TABLE and Managing Schema Objects: Complete Guide Oracle SQL ALTER TABLE and Managing Schema Objects: Complete Gui...

Read the full lesson

Oracle DBA Lesson 32D — Choosing a Point-in-Time Recovery

Point-in-time recovery deliberately returns the database to an earlier consistent state. Choose the boundary from the incident and the ...