Oracle Equi Join | Equi Join - oracle tutorial - sql tutorial




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
  • 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

Oracle EQUI JOIN Example

  • Let' take two tables "agents" and "customer".
 agent table
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

Agent data

 agent data

Customer table

 customer table

Customer data

 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:

 equi join output

Oracle Equi Join vs Inner Join

Oracle equi join vs inner join query

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

Related Searches to Equi Join | Oracle Equi Join

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×