Category: Oracle

Inner Join – is a join of two or more tables that returns only those rows that satisfy the join condition. Left Outer Join – is a query that performs an outer join of tables A and B and returns all...

The Oracle Self Join is a join of a table to itself. Oracle Self Join example Select * From users u, users m Where m.manager_id = u.user_id Order By u.user_id; Select * From customers c, customers s Where s.supplier_id = c.customer_id...

The Oracle Right Outer Join is a query that performs an outer join of tables A and B and returns all rows from B. Oracle Right Outer Join example Select cd.customer_id, cd.email, u.user_id, u.full_name From users u RIGHT OUTER JOIN customers_details...

The Oracle Outer Join returns all rows that match the join condition (inner join) and also returns rows of a left and right outer join. Oracle Outer Join example Select c.customer_id, c.name, cd.email, cd.phone From customers c, customers_details cd Where cd.customer_id...

The Oracle Non Equi-Join enables you to join two tables where there is no direct correspondence between columns in the tables. Oracle Non Equi-Join example Select c1.customer_id, c1.name, c2.amount From customers c1, contracts c2 Where c2.amount Between 100 and 200 Select...