Tutorial#66 Right outer Join in Oracle SQL Database by Rakesh Malviya equal connect coach
Explaining what is Right outer Join in Oracle SQL and How right outer join internally works / right outer join with on clause / right outer join with where clause this is one of the Types of join in Oracle SQL database or inner join, outer join, self-join, cross join in SQL
-----------------------------------------------------------------
Assignment Link:
https://drive.google.com/open?id=1kll...
------------------------------------------------------------------------
The Right outer joins return all records from the right table (table2), and the matched records from the Left table (table1). The result is NULL from the Left side if there is no match.
JOINS: Joins is nothing but it is used to retrieve the data from one or more than one table from the database.
#SQLTutorial #OracleTraining #RightouterJoin
Types of Joins: There are 4 types of joins
1. Inner Join
2. Outer Join-----a)Left outer join b)Right Outer join C)Full Outer join.
3. Self Join
4. Cross Join
In this series we cover the following topics:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.
follow me on:
Facebook Page:
https://www.facebook.com/LrnWthr-3193...
Contacts Email:
[email protected]
Instagram:
/ equalconnect
Twitter:
/ lrnwthr
Thank you for watching for the video Rakesh Malviya from equal connect coach