DELETE → Specifies that the trigger for the program is a Delete event. A Delete event is a DELETE statement
ALTER TRIGGER → Purpose Use the ALTER TRIGGER statement to enable, disable, or compile a database trigger. Note … : This statement does not change the declaration or definition of an existing trigger. To redeclare or … redefine a trigger, use the CREATE TRIGGER statement with the OR REPLACE keywords. See Also: CREATE
Restrictions on Trigger Conditions → If you specify this clause for a DML event trigger, then you must also specify FOR EACH ROW. Oracle … specify trigger conditions for INSTEAD OF trigger statements. You can reference object columns or their … in the trigger condition. pl/sql_block Specify the PL/SQL block that Oracle Database executes to … fire
DELETE ALL → Deletes all of the triggers for the specified object. Oracle OLAP disassociates the trigger program … keywords in a single TRIGGER statement. However, if you use the same keyword twice in a TRIGGER … . For example, assume that you code the following TRIGGER statement. TRIGGER PROPERTY progname1
Restrictions on BEFORE Triggers → You cannot specify a BEFORE trigger on a view or an object view. You can write to the: NEW value … but not to the: OLD value. AFTER Specify AFTER to cause the database to fire the trigger after … executing the triggering event. For row triggers, the trigger is fired after each affected row is changed.
Restrictions on Triggers on UPDATE Operations → You cannot specify UPDATE OF for an INSTEAD OF trigger. Oracle Database fires INSTEAD OF triggers … nested table column. ddl_event Specify one or more types of DDL statements that can cause the trigger … can create BEFORE and AFTER triggers for these events. Oracle Database fires the trigger in the … event any DDL operation performed
TRIGGER command → The TRIGGER command associates a previously-created program to an object and identifies the object … event that automatically executes the program; or a disassociates a trigger program from the object … . In order to assign a trigger program to an object, the object must be the one most recently defined … make it the current definition.
UPDATE → TRIGGER_AFTER_UPDATE or TRIGGER_BEFORE_UPDATE program. program-name The name of the trigger program. When … omitted for an event, the event does not trigger an action.
NAME → For a program identified as a trigger program using the TRIGGER command, returns the object for … which the trigger program is association. For a TRIGGER_AW, TRIGGER_DEFINE, TRIGGER_AFTER_UPDATE, or … trigger events, see TRIGGER command and TRIGGER_DEFINE. SUBEVENT When the value returned by EVENT is
CREATE TRIGGER → Purpose Use the CREATE TRIGGER statement to create and enable a database trigger, which is: A … call to a procedure implemented in PL/SQL or Java Oracle Database automatically executes a trigger … when specified conditions occur. When you create a trigger, the database enables it automatically … . You can subsequently
ASSIGN → Specifies that Oracle OLAP executes the specified program in response to a Assign event. An Assign event is executed when SET assigns values to variable, relation, worksheet object, or a formula. A program that is triggered by SET is executed each time Oracle OLAP assigns a value to the object for which the event was defined. Thus, a program triggered by an Assign event is often executed over and
DROP TRIGGER → Purpose Use the DROP TRIGGER statement to remove a database trigger from the database. See Also … : CREATE TRIGGER and ALTER TRIGGER Prerequisites The trigger must be in your own schema or you must have … the DROP ANY TRIGGER system privilege. To drop a trigger on DATABASE
TRIGGER function → The TRIGGER function retrieves the event, subevent, or name of the object or analytic workspace … that caused the execution of a trigger program (that is, a TRIGGER_DEFINE, TRIGGER_AFTER_UPDATE, or … TRIGGER_BEFORE_UPDATE program, or any program identified as a trigger program using the TRIGGER command … ). When
Restrictions on Trigger Implementation → The PL/SQL block of a trigger cannot contain transaction control SQL statements ( COMMIT, ROLLBACK … reference and use LOB columns in the trigger action inside the PL/SQL block. You can modify the: NEW … values but not the: OLD values of LOB columns within the trigger action. See Also: PL/SQL User's Guide … Trigger
MAINTAIN → Specifies that the trigger for the program is a Maintain event. A Maintain event is the execution
DELETE event-name → Deletes the triggers for the specified object events. Oracle OLAP disassociates the trigger program from the specified object event.
Restrictions on AFTER Triggers → You cannot specify an AFTER trigger on a view or an object view. You cannot write either the: OLD … implicitly creates an AFTER ROW trigger on the table. This trigger inserts a row into the materialized … fire the trigger instead of executing the triggering event. INSTEAD OF triggers are valid for DML … triggers
PROPERTY → Specifies that Oracle OLAP executes the specified program in response to a Property event. A Property event is the execution of a PROPERTY statement to create, modify, or delete an object property. A program that is triggered by a Property event is executed before the statement that triggered it.
Restrictions on INSTEAD OF Triggers → INSTEAD OF triggers are valid only for views. You cannot specify an INSTEAD OF trigger on a table … triggers is indeterminate. If your application requires that one trigger be fired before another of the … same type for the same statement, then combine these triggers into a single trigger whose trigger … action
Trigger Action → A trigger action is the procedure (PL/SQL block, Java program, or C callout) that contains the SQL … trigger restriction evaluates to true. Like stored procedures, a trigger action can: Contain SQL … , the statements in a trigger action have access to column values of the row being processed by the … trigger.