by Dexter | Dec 17, 2020 | Oracle SQL
We will be learning the usage of RIGHT OUTER JOIN in Oracle in this tutorial for joining more than two tables. There are three types of Outer Joins, i.e, Left Outer Join, Right Outer Join and Full Outer Join which are used when we want to keep all rows from either...
by Dexter | Dec 17, 2020 | Oracle SQL
In this tutorial, we will learn how to use LEFT JOIN or LEFT OUTER JOIN to join more than two tables. Generally, Joins are used for returning matching rows in both tables which satisfy the join condition. In some cases, we may want to keep all rows from either left or...
by Dexter | Dec 17, 2020 | Oracle SQL
In this tutorial, we will learn how to join two or more than two tables using INNER JOIN in Oracle. In relational databases, we use database normalization to store related data in different tables and to avoid redundancy. For this reason, we distribute data in several...
by Dexter | Dec 15, 2020 | Oracle SQL
Oracle Joins are used when we want to retrieve data from two or more tables. The process of storing data that is related to each other in different Oracle Tables to reduce redundancy of data and to save storage space is called Database Normalization. Often we need to...
by Dexter | Dec 5, 2020 | Oracle SQL
HAVING clause in Oracle is used with GROUP BY function to further narrow down or filter rows in a result group as per our requirement. HAVING is similar to the WHERE clause except it only works for filtering rows in groups and is used after the GROUP BY clause in a...
by Dexter | Dec 5, 2020 | Oracle SQL
GROUP BY clause is used in the SELECT statement to retrieve the result set by group. The query using GROUP BY clause returns only one row per group. It is often used in conjunction with aggregate functions like AVG, MAX, MIN, COUNT etc. Syntax The general syntax of...