Equi Join
Oracle Database Basic Course
Created by :
Database, Oracle
course
Programming, Software and application
1756
2020-12-07 03:13:23
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.

- Database Overview
- What Is Oracle Database
- History of Oracle Database
- Why Oracle Database
- Features of Oracle Database
- Oracle Vs. SQL Server: Key Differences
- Oracle Vs. MySQL Server: Key Differences
- Oracle Vs. NoSQL
- Install Oracle Database Server
- Oracle Database Sample Schema
- Execute Sample Database
- Connect to SQL Developer and Other SQL Editor