You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for TRIGGER


1 to 20 of 586 results. Previous page Prev  Next next page
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.