Blog

This article explores the concept of horizontal attribute storage in Oracle databases. It explains how to store dynamic attributes as rows instead of columns, provides practical examples, and compares horizontal storage with traditional vertical storage. Learn about its advantages, disadvantages, and SQL techniques for data transformation.

A practical solution for scenarios where you need to change the data source in Oracle without modifying the main procedure code. A simple approach using views (VIEW) for seamless switching between old and new data.

This article explains what hierarchical queries in SQL are, why they are needed, and how to use them for working with tree-like data structures. Using a product catalog as an example, you’ll see how to create a table, set up relationships, fill it with test data, and write practical SQL queries to display and analyze the hierarchy.

This guide provides a comprehensive overview of SQL JOIN operations, with special attention to NULL value behavior in Oracle databases. Through practical examples using two test tables, we explore all major JOIN types and their specific behaviors when dealing with NULL values.