Oracle Joins
Oracle Semi Join
Semi-join is introduced in Oracle 8.0. It provides an efficient method of performing a WHERE EXISTS sub-query. A semi-join returns one copy of each row…
Oracle Anti Join
Anti-join is used to make the queries run faster. It is a very powerful SQL construct Oracle offers for faster queries. Anti-join between two tables…
Oracle Cross Join
The CROSS JOIN specifies that all rows from first table join with all of the rows of second table. If there are “x” rows in…
Oracle SELF JOIN
Self Join is a specific type of Join. In Self Join, a table is joined with itself (Unary relationship). A self join simply specifies that…
Oracle EQUI JOIN
Oracle Equi join returns the matching column values of the associated tables. It uses a comparison operator in the WHERE clause to refer equality. Syntax…
Oracle OUTER JOIN
An outer join is similar to equijoin but it gets also the non-matched rows from the table. It is categorized in Left Outer Join, Right…
Oracle INNER JOIN
Inner Join is the simplest and most common type of join. It is also known as simple join. It returns all rows from multiple tables…
Oracle Joins
Join is a query that is used to combine rows from two or more tables, views, or materialized views. It retrieves data from multiple tables…