Engineering Journal

Writing & Insights

Deep dives into Data Architecture, BI strategy, and modern software engineering.

May 2, 20263 min read

Oracle SQL A Comparative Guide to CTEs, Views, Temporary Tables, and Materialized Views

Today, we're diving into Oracle SQL views, temporary tables, Common Table Expressions (CTEs), and subqueries. There's a lot of debate in this space – some swear by CTEs, others by temporary tables. Bu…

oracle SQLSQL CTEsSubquiresviews

Read article

How to Integrate API Data into Oracle Database Using PL/SQL

In this blog post, we'll walk through the process of integrating data from an external API into an Oracle database using PL/SQL. Specificall…

SQLOraclePI

Efficiently Loading CSV Data into Oracle DB: Solving the Merge Problem

Problem Statement In many data-driven environments, we often receive data in CSV format from upstream systems. The challenge lies not jus…

OracleBIDatabasen