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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Truncate Table
Published by :
Obay Salah , December 1, 2024
In Oracle, TRUNCATE TABLE statement is used to remove all records from a table. It works same as DELETE statement but without specifying a WHERE claus... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Delete Statement
Published by :
Obay Salah , December 1, 2024
In Oracle, DELETE statement is used to remove or delete a single record or multiple records from a table.SyntaxDELETE FROM table_name &... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Update Statement
Published by :
Obay Salah , December 1, 2024
In Oracle, UPDATE statement is used to update the existing records in a table. You can update a table in 2 ways.Traditional Update table methodSyntax:... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Insert ALL statement
Published by :
Obay Salah , December 1, 2024
The Oracle INSERT ALL statement is used to insert multiple rows with a single INSERT statement. You can insert the rows into one table or multiple tab... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Insert Statement
Published by :
Obay Salah , December 1, 2024
In Oracle, INSERT statement is used to add a single record or multiple records into the table.Syntax: (Inserting a single record using the Values keyw... Continue Reading