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.
NATURAL 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 NATURAL JOIN in the front clause JOINs two or more tables by matching column names, and returns matching rows from both tables where there's a match, with less typing. I'll show an example and point out one of the downsides of using NATURAL JOIN. Here are the JOIN types you can perform in a SELECT statement in Oracle. An inner JOIN, also known as a 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 NATURAL JOIN in this video. Here are the comparable syntaxes between the ANSI standard and Oracle-specific syntax for NATURAL JOINs. But wait, there's no equivalent syntax using Oracle-native JOINs. In other words: JOINing two or more tables by doing an EQUIJOIN on matching column names in the table is not…
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.