الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Anti Join
نشر بواسطة :
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Cross Join
نشر بواسطة :
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle SELF JOIN
نشر بواسطة :
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle EQUI JOIN
نشر بواسطة :
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle OUTER JOIN
نشر بواسطة :
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle INNER JOIN
نشر بواسطة :
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Joins
نشر بواسطة :
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle MINUS operator
نشر بواسطة :
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 statementEach SELECT sta... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle INTERSECT Operator
نشر بواسطة :
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle UNION ALL Operator
نشر بواسطة :
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... اكمل القراءة