الملف الشخصي
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle UNION Operator
نشر بواسطة :
Obay Salah , December 1, 2024
In Oracle, UNION operator is used to combine the result sets of two or more Oracle SELECT statements. It combines the both SELECT statement and remove... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle HAVING Clause
نشر بواسطة :
Obay Salah , December 1, 2024
In Oracle, HAVING Clause is used with GROUP BY Clause to restrict the groups of returned rows where condition is TRUESyntaxSELECT expression1,&nb... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Group BY Clause
نشر بواسطة :
Obay Salah , December 1, 2024
In Oracle GROUP BY clause is used with SELECT statement to collect data from multiple records and group the results by one or more columns.Syntax:SELE... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Order BY Clause
نشر بواسطة :
Obay Salah , December 1, 2024
In Oracle, ORDER BY Clause is used to sort or re-arrange the records in the result set. The ORDER BY clause is only used with SELECT statement.SyntaxS... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Distinct Clause
نشر بواسطة :
Obay Salah , December 1, 2024
Oracle DISTINCT clause is used to remove the duplicate records from the result set. It is only used with SELECT statementSyntaxSELECT DISTINCT&nb... اكمل القراءة