Oracle Anti Join
Published by : Obay Salah , December 2, 2024
Anti-join is used to make the queries run faster. It is a very powerful SQL construct Oracle offers for faster queries.Anti-join between two tables re... Continue Reading
Oracle Cross Join
Published by : Obay Salah , December 2, 2024
The CROSS JOIN specifies that all rows from first table join with all of the rows of second table. If there are "x" rows in table1 and "y" rows in tab... Continue Reading
Oracle SELF JOIN
Published by : Obay Salah , December 2, 2024
Self Join is a specific type of Join. In Self Join, a table is joined with itself (Unary relationship). A self join simply specifies that each rows of... Continue Reading
Oracle EQUI JOIN
Published by : Obay Salah , December 2, 2024
Oracle Equi join returns the matching column values of the associated tables. It uses a comparison operator in the WHERE clause to refer equality.Synt... Continue Reading
Oracle OUTER JOIN
Published by : Obay Salah , December 2, 2024
An outer join is similar to equijoin but it gets also the non-matched rows from the table. It is categorized in Left Outer Join, Right Outer Join and... Continue Reading
Oracle INNER JOIN
Published by : Obay Salah , December 2, 2024
Inner Join is the simplest and most common type of join. It is also known as simple join. It returns all rows from multiple tables where the join cond... Continue Reading
Oracle Joins
Published by : Obay Salah , December 1, 2024
Join is a query that is used to combine rows from two or more tables, views, or materialized views. It retrieves data from multiple tables and creates... Continue Reading
Oracle MINUS operator
Published by : Obay Salah , December 1, 2024
In Oracle, MINUS operator is used to return all rows in the first SELECT statement that are not returned by the second SELECT statement.Each SELECT st... Continue Reading
Oracle INTERSECT Operator
Published by : Obay Salah , December 1, 2024
In Oracle, INTERSECT Operator is used to return the results of 2 or more SELECT statement. It picks the common or intersecting records from compound S... Continue Reading
Oracle UNION ALL Operator
Published by : Obay Salah , December 1, 2024
In Oracle, the UNION ALL operator is used to combine the result sets of 2 or more SELECT statements. It is different from UNION operator in a way that... Continue Reading