Right Outer Join Oracle - oracle tutorial - sql tutorial
![Oracle right outer join](https://wikitechy.com/tutorials/oracle/img/oracle-images/oracle-right-outer-join.gif)
Learn oracle - oracle tutorial - Oracle right outer join - oracle examples - oracle programs
What is Right outer join in Oracle ?
- Right outer join returns all rows from the RIGHT-hand table specified in the ON condition and only those rows from the other table where the joined fields are equal (join condition is met).
![representation of right outer join](https://wikitechy.com/tutorials/oracle/img\oracle-images\right-outer-join-representation.png)
Syntax :
SELECT columns
FROM table1
RIGHT [OUTER] JOIN table2
ON table1.column = table2.column;
click below button to copy the code. By - oracle tutorial - team
Example :
SELECT orders.orderid, orders.Customer_Name, wikitechy_employee.name
FROM wikitechy_employee
RIGHT OUTER JOIN orders
ON wikitechy_employee.id = orders.id;
click below button to copy the code. By - oracle tutorial - team
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql
Sample Database:
- We have a table called wikitechy_employee with four fields (id, name, position, and city). It contains the following data:
![output of right outer join oracle](https://wikitechy.com/tutorials/oracle/img\oracle-images\oracle-right-outer-join-table-output.png)
- We have another table called orders with three fields (id, customer_name, and orderid).
![output2 of right outer join oracle](https://wikitechy.com/tutorials/oracle/img\oracle-images\oracle-right-outer-join-table-2-output.png)
Right Outer Join:
![right outer join output and query](https://wikitechy.com/tutorials/oracle/img\oracle-images\oracle-right-outer-join-query-and-output.png)
- The above oracle sql query would return all rows from the orders table and only those rows from the wikitechy_employee table where the joined fields are equal.
- If a id value in the orders table does not exist in the wikitechy_employee table, all fields in the wikitechy_employee table will display as <null>in the result set.
Oracle ALL Joins
![Oracle join query](https://wikitechy.com/tutorials/oracle/img\oracle-images\sql-joins-all.gif)
Oracle Join Query - Inner Join Query - Left Outer Join Query - Right Outer Join Query - Full Outer Join Query