From the course: Oracle Database 19c: Basic SQL
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
FULL (OUTER) JOIN
- One of the key components of a select statement is the ability to join two or more tables on one or more columns. And return columns from those tables. A full outer join, or just full join in the from clause joins two or more tables and returns rows in the joined from both the table on the left and the table on the right of the joined. And returns matching rows when there is a match. I'll describe how that works and compare the NC syntax to the oracles specific syntax. Here are the join types you can perform in a select statement in oracle. An inner join, also known as join. A left join, also known as left outer join. A right join, also known as right outer join. Full join, also known as full outer join. Natural join and cross join. I'll review the full outer join in this video. Here are the comparable syntaxes between the ANSI standard and Oracle specific syntax for the full outer joins. Both fully supported in Oracle. In each syntax I've highlighted the statements that enable the…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.