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.
RIGHT (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 right outer join, or just right join, in the from clause joins one or more tables and returns rows in the join from the table on the right of the join and returns matching rows from the other table if there's a match. I'll describe how that works and compare the ANSI syntax to the oracle specific syntax. Here are the join types you can perform in a select statement in oracle. A 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 outer join. Natural join. And cross join. I'll review the right outer join in this video. Here are the comprable syntaxes between the ANSI standard and oracle specific syntax for right outer joins, both fully supported in oracle. In each syntax, I've highlighted the statements that enable the corresponding syntax. The ANSI syntax does…
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.