What is 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.
• When you relate two tables on the join condition by equating the columns with equal(=) symbol, then it is called an Euqi-Join. Equi-joins are also called as simple joins.

Syntax:

SELECT column_list 
FROM table1, table2....
WHERE table1.column_name =
table2.column_name;

click below button to copy the code. By - oracle tutorial - team

Copy Code

• 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

SELECT *
FROM table1 
JOIN table2
[ON (join_condition)]

click below button to copy the code. By - oracle tutorial - team

Copy Code

Oracle EQUI JOIN Example

• Let' take two tables "agents" and "customer".

oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

Agent data

Customer table

Customer data

• Execute this query

• SELECT agents.agent_city,customer.last_name,
• customer.first_name
• FROM agents,customer
• WHERE agents.agent_id=customer.customer_id;

oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

Output:

Oracle Equi Join vs Inner Join

Oracle equi join vs inner join query

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning