Outer Joins

Description

Oracle Note on Outer Joins, created by souravi sinha on 28/11/2018.
souravi sinha
Note by souravi sinha, updated more than 1 year ago
souravi sinha
Created by souravi sinha over 5 years ago
1
0

Resource summary

Page 1

Definition

  Outer joins give all data from 1 table and common data from other table.  

Types

Left outer join :-  All data from left table and only matched from right table. Right Outer Join :- All data from right table and only matched from left table. Full Outer Join:- All data from both the table. matched data of both the tables.  

Show full summary Hide full summary

Similar

Fusion HCM Essencials
Essam Sakr
Midterm 2 (Chapter 5 - 13)
Yorria Raine
120-1057-21: Oracle Project Management Cloud 2021 Implementation Essentials - Full
Daniel Cloud
1Z0-062 Oracle Admin Exam
Abdullah Albyati
Select statement
Felipe Farías
Oracle OCI 1Z0-997-21
Jorge Luis Hidalgo Herrera
ARCS_V2
Preston Oakes
Tuning de Banco de Dados Oracle
Diego Melo
Indexes
souravi sinha
Oracle Database SQL Language Reference
Jason Shanks
Fusion HCM Essencials
Ahmed Khaled8613