الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle ENABLE Trigger
نشر بواسطة :
Obay Salah , December 3, 2024
The ALTER TRIGGER statement is used to enable a trigger.SyntaxALTER TRIGGER trigger_name ENABLE; Parameterstrigger_na... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle DISABLE Trigger
نشر بواسطة :
Obay Salah , December 3, 2024
The ALTER TRIGGER statement is used to disable a trigger.SyntaxALTER TRIGGER trigger_name DISABLE; Parameterstrigger_... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle DROP Trigger
نشر بواسطة :
Obay Salah , December 3, 2024
In Oracle, DROP TRIGGER statement is used to drop the trigger if you find that you need to remove it from the database.SyntaxDROP TRIGGER tr... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle After INSERT/UPDATE/DELETE Trigger
نشر بواسطة :
Obay Salah , December 3, 2024
This statement specifies that Oracle will fire this trigger AFTER the INSERT/UPDATE or DELETE operation is executed.SyntaxCREATE [ ... اكمل القراءة
الملف الشخصي
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Before INSERT/UPDATE/DELETE Trigger
نشر بواسطة :
Obay Salah , December 3, 2024
This statement specifies that Oracle will fire this trigger BEFORE the INSERT/UPDATE or DELETE operation is executed.SyntaxCREATE [&nbs... اكمل القراءة
الملف الشخصي
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... اكمل القراءة