الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Trigger
نشر بواسطة :
Obay Salah , December 3, 2024
In Oracle, you can define procedures that are implicitly executed when an INSERT, UPDATE or DELETE statement is issued against the associated table. T... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Cursor
نشر بواسطة :
Obay Salah , December 3, 2024
A cursor is a pointer to a private SQL area that stores information about the processing of a SELECT or DML statements like INSERT, UPDATE, DELETE or... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Function
نشر بواسطة :
Obay Salah , December 3, 2024
A function is a subprogram that is used to return a single value. You must declare and define a function before invoking it. It can be declared and de... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Procedures
نشر بواسطة :
Obay Salah , December 3, 2024
A procedure is a group of PL/SQL statements that can be called by name. The call specification (sometimes called call spec) specifies a java method or... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Semi Join
نشر بواسطة :
Obay Salah , December 2, 2024
Semi-join is introduced in Oracle 8.0. It provides an efficient method of performing a WHERE EXISTS sub-query.A semi-join returns one copy of each row... اكمل القراءة
الملف الشخصي
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... اكمل القراءة