Oracle 19c SQL

  1. Home
  2. Docs
  3. Oracle 19c SQL
  4. 4 Joins in Oracle

4 Joins in Oracle

What you’ll learn in this Chapter

✓ What is a Join
✓ Types of Joins
✓ Cartesian Product vs Joins
✓ ANSI Joins

Overview

Relation between tables is the core concept in RDBMS. We recommend you to go through our RDBMS Course for better clarity on concepts.
Oracle JOIN is used to retrieve data from multiple tables, views or materialized views. In SQL, a JOIN is performed whenever multiple tables appear in queries FROM clause.

Articles

Was this article helpful to you? Yes No

How can we help?