The Oracle Alias Column is used to temporarily rename a column. Oracle Alias Column example Select first_name ||' '|| last_name AS full_name, code AS id From customers; Select o1.offer_id, o1.amount, ( Select count(*) From offers o2 Where o1.amount = o2.amount )...
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...