JOINS in Oracle


To combine rows from multiple tables, the Oracle Join Query is used. It creates a new table as the end result. It is often used to combine data from two or more views, or materialized views. There is however one mandatory condition for using the JOIN Query in Oracle and that is the condition itself. In simple words, there should be at least one JOIN condition for the joining process to complete or to take place.

Types of Joins: 

There are mainly seven types of Joins that the Oracle database supports. These are:

  • Inner or Simple Joins
  • Outer Joins
  • Equi Joins
  • Self Joins
  • Cross or Cartesian Joins
  • Anti Joins
  • Semi-Joins


Please follow and like us:
Content Protection by