Home >> Oracle >> Joins in Oracle

Joins in Oracle

It is a way to combine information from two or more relations. it is a binary relation(two relations to operate).

There are seven types-

1-Inner Join

2-Natural join

3-Outer join

4-Self join

5)-Equi Join

6)-Anti Join

7)-Semi Join

Post Your Comment

Next Questions
Inner Join
Outer Join
Self Join
Cross Join
Equi Join
Anti Join
Semi Join
Create database
Drop database
Create table
Drop table
Truncate table
Alter Table
Create table AS
Global Temporary tables
SELECT Query
INSERT Query
INSERT ALL Query
UPDATE Query
DELETE Query
WHERE clause
AND Clause
OR Clause
LIKE clause
IN clause

Copyright ©2022 coderraj.com. All Rights Reserved.