الملف الشخصي
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Truncate Table
نشر بواسطة :
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Delete Statement
نشر بواسطة :
Obay Salah , December 1, 2024
In Oracle, DELETE statement is used to remove or delete a single record or multiple records from a tableSyntaxDELETE FROM table_name &n... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Update Statement
نشر بواسطة :
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 methodSyntaxU... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Insert ALL statement
نشر بواسطة :
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... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Insert Statement
نشر بواسطة :
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... اكمل القراءة