Results for TRIGGER


1 to 20 of 586 results. Prev  Next
Results per page:   20  | 40 | 60


DML Reference, 10g Release 1 (10.1)

TRIGGER command

DELETESpecifies that the trigger for the program is a Delete event. A Delete event is a DELETE statement

SQL Reference, 10g Release 1 (10.1)

ALTER TRIGGER

ALTER TRIGGERPurpose 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

SQL Reference, 10g Release 1 (10.1)

CREATE TRIGGER

Restrictions on Trigger ConditionsIf 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

DML Reference, 10g Release 1 (10.1)

TRIGGER command

DELETE ALLDeletes 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

SQL Reference, 10g Release 1 (10.1)

CREATE TRIGGER

Restrictions on BEFORE TriggersYou 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.

SQL Reference, 10g Release 1 (10.1)

CREATE TRIGGER

Restrictions on Triggers on UPDATE OperationsYou 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

DML Reference, 10g Release 1 (10.1)

TRIGGER command

TRIGGER commandThe 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.

DML Reference, 10g Release 1 (10.1)

TRIGGER command

UPDATETRIGGER_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.

DML Reference, 10g Release 1 (10.1)

TRIGGER function

NAMEFor 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

SQL Reference, 10g Release 1 (10.1)

CREATE TRIGGER

CREATE TRIGGERPurpose 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

DML Reference, 10g Release 1 (10.1)

TRIGGER command

ASSIGNSpecifies 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

SQL Reference, 10g Release 1 (10.1)

DROP TRIGGER

DROP TRIGGERPurpose 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

DML Reference, 10g Release 1 (10.1)

TRIGGER function

TRIGGER functionThe 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

SQL Reference, 10g Release 1 (10.1)

CREATE TRIGGER

Restrictions on Trigger ImplementationThe 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

DML Reference, 10g Release 1 (10.1)

TRIGGER command

MAINTAINSpecifies that the trigger for the program is a Maintain event. A Maintain event is the execution

DML Reference, 10g Release 1 (10.1)

TRIGGER command

DELETE event-nameDeletes the triggers for the specified object events. Oracle OLAP disassociates the trigger program from the specified object event.

SQL Reference, 10g Release 1 (10.1)

CREATE TRIGGER

Restrictions on AFTER TriggersYou 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

DML Reference, 10g Release 1 (10.1)

TRIGGER command

PROPERTYSpecifies 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.

SQL Reference, 10g Release 1 (10.1)

CREATE TRIGGER

Restrictions on INSTEAD OF TriggersINSTEAD 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

Concepts, 10g Release 1 (10.1)

22 Triggers

Trigger ActionA 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.


Was this page helpful?