Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle UNION Operator
Published by :
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... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle HAVING Clause
Published by :
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 TRUE.Syntax:SELECT expression1,&... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Group BY Clause
Published by :
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... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Order BY Clause
Published by :
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.Syntax:... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Distinct Clause
Published by :
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 statement.Syntax:SELECT DISTINCT&... Continue Reading