Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle ENABLE Trigger
Published by :
Obay Salah , December 3, 2024
The ALTER TRIGGER statement is used to enable a trigger.SyntaxALTER TRIGGER trigger_name ENABLE; Parameterstrigger_na... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle DISABLE Trigger
Published by :
Obay Salah , December 3, 2024
The ALTER TRIGGER statement is used to disable a trigger.SyntaxALTER TRIGGER trigger_name DISABLE; Parameterstrigger_... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle DROP Trigger
Published by :
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... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle After INSERT/UPDATE/DELETE Trigger
Published by :
Obay Salah , December 3, 2024
This statement specifies that Oracle will fire this trigger AFTER the INSERT/UPDATE or DELETE operation is executed.SyntaxCREATE [ ... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Before INSERT/UPDATE/DELETE Trigger
Published by :
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... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Trigger
Published by :
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... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Cursor
Published by :
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... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Function
Published by :
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... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Procedures
Published by :
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... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Semi Join
Published by :
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... Continue Reading