88
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.
Syntax
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.
Syntax
Oracle EQUI JOIN Example
Let’ take two tables “agents” and “customer”.
Agents table
Agent data
Customer table
Customer data
Execute this query
Output
Next TopicOracle SELF JOIN