Oracle EQUI JOIN
Oracle Equi join returns the matching column values of the associated tables. It uses a comparison operator in the WHERE clause to refer equality.
Equijoin also can be performed by using JOIN keyword followed by ON keyword and then specifying names of the columns along with their associated tables to check equality.
Oracle EQUI JOIN Example
Let' take two tables "agents" and "customer".
Execute this query