ORACLE
ORACLE JOINS
INNER JOIN
OUTER JOIN
EQUI JOIN
SELF JOIN
CROSS JOIN
ANTI JOIN
SEMI JOIN
ORACLE TUTORIAL
Oracle Introduction
What Is Oracle
ORACLE TABLES
Create Tables
Create Table As
Alter Table
Drop Table
Global Temorary Tables
Local Temorary Tables
ORACLE VIEWS
Create View
ORACLE QUERIES
SELECT
INSERT
INSERT ALL
UPDATE
DELETE
TRUNCATE TABLE
ORACLE CLAUSES
DISTINCT
FROM
ORDER BY
GROUP BY
HAVING
ORACLE OPERATORS
UNION
UNION ALL
INTERSECT
MINUS
ORACLE ADVANCE
PROCEDURES
FUNCTION
CURSOR
TRIGGER

EQUI JOIN



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 :
SELECT column_list   
FROM table1, table2....  
WHERE table1.column_name =  
table2.column_name;  

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)]   

Oracle EQUI JOIN Example

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


Agents table :

AGENT_IDAGENT_NAMEAGENT_CITY
3AjayAhmedabad
7NirupamLondon
11TejaMumbai

Customers table :

CUSTOMER_IDFIRST_NAMELAST_NAME
1NehaUllal
2RichaKohli
3SwethaPandit
4JansiKapoor

Execute this query

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

Output :

AGENT_CITYFIRST_NAMELAST_NAME
AhmedabadSwethaPandit


What Is Oracle

What Is Oracle

posted on 2019-11-29 01:11:21 - ORACLE Tutorials


TRIGGER

ORACLE - Trigger

posted on 2019-11-28 22:14:22 - ORACLE Tutorials


CURSOR

ORACLE - Cursor

posted on 2019-11-28 22:13:54 - ORACLE Tutorials


MySQL TRIGGERS

MySQL - Triggers

posted on 2019-11-29 21:44:07 - mysql Tutorials


Grant_ Revoke Privilege

MySQL - Grant_ Revoke Privilege

posted on 2019-11-26 23:15:04 - mysql Tutorials


MySQL Vs SQL

MySQL Vs SQL

posted on 2019-11-25 05:02:26 - mysql Tutorials