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 60 of 908 results. Previous page Prev  Next next page
Results per page:  20 | 40 |  60 


Database SQL Language Reference, 11g Release 2 (11.2)

DROP TRIGGER

DROP TRIGGERcomplete information on creating, altering, and dropping triggers. 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

Database SQL Language Reference, 11g Release 2 (11.2)

CREATE TRIGGER

CREATE TRIGGERthe CREATE TRIGGER statement to create a database trigger, which is: A stored PL/SQL block associated … implemented in PL/SQL or Java Oracle Database automatically executes a trigger when specified conditions … occur. See Also: ALTER TRIGGER and DROP TRIGGER Prerequisites To create a trigger

Database SQL Language Reference, 11g Release 2 (11.2)

ALTER TRIGGER

ALTER TRIGGERthe 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 TRIGGER

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Trigger Restrictionsthese restrictions: Trigger Size Restriction Trigger LONG and LONG RAW Data Type Restrictions Mutating … -Table Restriction Only an autonomous trigger can run TCL or DDL statements. For information about … autonomous triggers, see \"Autonomous Triggers\". A trigger cannot invoke a subprogram that runs … transaction

Database PL/SQL Language Reference, 11g Release 2 (11.2)

DROP TRIGGER Statement

DROP TRIGGER StatementThe DROP TRIGGER statement drops a database trigger from the database. Topics Prerequisites Syntax … Semantics Example Related Topics Prerequisites The trigger must be in your schema or you must have … the DROP ANY TRIGGER system privilege. To drop a trigger on DATABASE in another user's schema, you

Database PL/SQL Language Reference, 11g Release 2 (11.2)

ALTER TRIGGER Statement

ALTER TRIGGER StatementThe ALTER TRIGGER statement enables, disables, compiles, or renames 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 clause. Topics … Prerequisites

Database PL/SQL Language Reference, 11g Release 2 (11.2)

CREATE TRIGGER Statement

CREATE TRIGGER StatementThe CREATE TRIGGER statement creates or replaces a database trigger, which is either of these: A … invocation of a procedure implemented in PL/SQL or Java The database automatically runs a trigger … Prerequisites To create a trigger in your schema on a table in your schema or on your schema ( SCHEMA … ), you must

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Trigger Enabling and DisablingBy default, the CREATE TRIGGER statement creates a trigger in the enabled state. To create a … trigger in the disabled state, specify DISABLE. Creating a trigger in the disabled state lets you ensure … that it compiles without errors before you enable it. Some reasons to temporarily disable a trigger

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Trigger Size RestrictionThe size of the trigger cannot exceed 32K. If the logic for your trigger requires much more than 60 … subprogram from the trigger. For information about subprograms invoked by triggers, see \"Subprograms Invoked by Triggers\".

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Trigger Changing and DebuggingTo change a trigger, you must either replace or re-create it. (The ALTER TRIGGER statement only … enables, disables, compiles, or renames a trigger.) To replace a trigger, use the CREATE TRIGGER … statement with the OR REPLACE clause. To re-create a trigger, first drop it with the DROP

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Trigger Design Guidelines(regardless of which user or application issues the triggering statement). For example, use a trigger to … duplicate database features. For example, do not create a trigger to reject invalid data if you can do … assign a value to a global package variable in a row trigger if the current value of the variable … depends on the row

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Trigger Compilation, Invalidation, and RecompilationThe CREATE TRIGGER statement compiles the trigger and stores its code in the database. If a … compilation error occurs, the trigger is still created, but its triggering statement fails, except in these … cases: The trigger was created in the disabled state. The triggering event is AFTER STARTUP ON … logs on as

Database SQL Language Reference, 11g Release 2 (11.2)

SQL Statements: ALTER TRIGGER to COMMIT

13 SQL Statements: ALTER TRIGGER to COMMITThis chapter contains the following SQL statements: ALTER TRIGGER ALTER TYPE ALTER USER ALTER VIEW ANALYZE ASSOCIATE STATISTICS AUDIT CALL COMMENT COMMIT

Database SQL Language Reference, 11g Release 2 (11.2)

SQL Statements: CREATE SYNONYM to CREATE TRIGGER

16 SQL Statements: CREATE SYNONYM to CREATE TRIGGERThis chapter contains the following SQL statements: CREATE SYNONYM CREATE TABLE CREATE TABLESPACE CREATE TRIGGER

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Space for Schema Objects

Resumable Space Allocation Example: Registering an AFTER SUSPEND TriggerIn the following example, a system wide AFTER SUSPEND trigger is created and registered as user SYS … at the database level. Whenever a resumable statement is suspended in any session, this trigger can … interval is reset to 8 hours. Here are the statements for this example: CREATE OR REPLACE TRIGGER … resumable_default AFTER

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Trigger LONG and LONG RAW Data Type RestrictionsRAW Variables\" ), triggers have these restrictions: A trigger cannot declare a variable of the LONG … or LONG RAW data type. A SQL statement in a trigger can reference a LONG or LONG RAW column only if … the column data can be converted to the data type CHAR or VARCHAR2. A trigger cannot use the

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Space for Schema Objects

Using a LOGON Trigger to Set Default Resumable Modeinitialization parameter, is that you can register a database level LOGON trigger to alter a user's session … Oracle Database does not guarantee the order of trigger invocation.

Database Concepts, 11g Release 2 (11.2)

Glossary

triggerA PL/SQL or Java procedure that fires when a table or view is modified or when specific user or database actions occur. Procedures are explicitly run, whereas triggers are implicitly run.

OLAP DML Reference, 11g Release 2 (11.2)

TRIGGER command

DELETE ALLDeletes all of the triggers for the specified object. Oracle OLAP disassociates the trigger program … the keywords in a single TRIGGER statement. However, if you use the same keyword twice in a TRIGGER … ignored. For example, assume that you code the following TRIGGER statement. TRIGGER PROPERTY progname1

OLAP DML Reference, 11g Release 2 (11.2)

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.

OLAP DML Reference, 11g Release 2 (11.2)

TRIGGER command

UPDATEWhen the object has been acquired using ACQUIRE in an analytic workspace that is attached in multiwriter mode, specifies that Oracle OLAP executes the specified program immediately after the object is updated. Tip: To specify processing when the entire analytic workspace is updated, create a TRIGGER_AFTER_UPDATE or TRIGGER_BEFORE_UPDATE program.

OLAP DML Reference, 11g Release 2 (11.2)

TRIGGER command

program-nameThe name of the trigger program. When omitted for an event, the event does not trigger an action … . DELETE event-name Deletes the triggers for the specified object events. Oracle OLAP disassociates the trigger program from the specified object event.

OLAP DML Reference, 11g Release 2 (11.2)

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 … information on events, see \"Trigger Programs\" and TRIGGER command SUBEVENT When the value returned

OLAP DML Reference, 11g Release 2 (11.2)

TRIGGER command

To assign a trigger program to an object, the object must be the one most recently defined or considered…To assign a trigger program to an object, the object must be the one most recently defined or … the current definition. See also: \"Trigger Programs\" and the TRIGGER function. Syntax TRIGGER … many times in a single TRIGGER statement; however, in this case, Oracle OLAP ignores all but the … .

OLAP DML Reference, 11g Release 2 (11.2)

TRIGGER command

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

OLAP DML Reference, 11g Release 2 (11.2)

TRIGGER command

ASSIGNSpecifies that Oracle OLAP executes the specified program in response to an 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

OLAP DML Reference, 11g Release 2 (11.2)

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

OLAP DML Reference, 11g Release 2 (11.2)

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 disassociates a trigger program from the object.

SQL Developer User's Guide, 11g Release 2 (11.2)

Dialog Boxes for Creating/Editing Objects

Create TriggerThe following information applies to a trigger, which is which is a stored PL/SQL block associated … implemented in PL/SQL or Java. The trigger is automatically executed when the specified conditions occur … . Schema: Database schema in which to create the trigger. Name: Name of the trigger. Must be unique … the

OLAP DML Reference, 11g Release 2 (11.2)

OLAP DML Programs

Trigger Programsthat can trigger the execution of OLAP DML programs. Programs triggered by DEFINE, MAINTAIN … , PROPERTY, UPDATE, or SET commands, are called object trigger programs and are discussed in this section … and in the topic for the TRIGGER command. A program named TRIGGER_AW that is defined within one … or deleted. See the discussion

Spatial GeoRaster Developer's Guide, 11g Release 2 (11.2)

GeoRaster Operations

3.1.3 GeoRaster DML Triggerautomatically creates a unique DML trigger for each GeoRaster column whenever a user creates a … SDO_GEOR_UTL.createDMLTrigger procedure to create the DML trigger on each added GeoRaster column. The trigger … automatically performs the following actions when the trigger is fired: After an insert operation, the

Application Express SQL Workshop and Utilities Guide, 11g Release 2 (11.2)

Managing Database Objects with Object Browser

Compiling a Triggerfunction because this is just a view of the object within the database. To compile a trigger in … appears. From the Object list, select Triggers. From the Object Selection pane, select a trigger … . The Details view appears. Click Compile to compile the current trigger. Compiling re-creates the

Application Express SQL Workshop and Utilities Guide, 11g Release 2 (11.2)

Managing Database Objects with Object Browser

Dropping a TriggerTo save drop a trigger in Object Browser: On the Workspace home page, click SQL Workshop and then … Selection pane, select a trigger. The Details view appears. Click Drop to delete the current trigger.

Streams Concepts and Administration, 11g Release 2 (11.2)

Advanced Apply Process Concepts

Trigger Firing Propertyprocedure in the DBMS_DDL package. This procedure lets you specify whether a trigger always fires, fires … overloaded. Set a trigger's firing property in one of the following ways: To specify that a trigger always … fires, set the fire_once procedure parameter to FALSE. To specify that a trigger fires once, set the … fire_once

Application Express SQL Workshop and Utilities Guide, 11g Release 2 (11.2)

Managing Database Objects with Object Browser

Editing a TriggerWhen you edit a trigger you can edit the code manually, perform a search and replace, and compile … the trigger. Editing a Trigger Manually To edit a trigger manually: On the Workspace home page, click … . From the Object Selection pane, select a trigger. Select the Code tab and then click Edit to

XML DB Developer's Guide, 11g Release 2 (11.2)

Repository Access Control

path-index triggerdatabase trigger, called the path-index trigger, that ensures that the last-modified information for a

Application Express SQL Workshop and Utilities Guide, 11g Release 2 (11.2)

Managing Database Objects with Object Browser

Browsing a TriggerTo browse a trigger in Object Browser: On the Workspace home page, click SQL Workshop and then … pane, select a trigger. The Details view appears. Summary of Available Views Click the tabs at the … top of the page to view different reports about the trigger. Table 1-10 describes all available … details about the current trigger.

Application Express SQL Workshop and Utilities Guide, 11g Release 2 (11.2)

Managing Database Objects with Object Browser

Downloading a TriggerTo save the current trigger as a file: On the Workspace home page, click SQL Workshop and then … pane, select a trigger. The Details view appears. Click Download to save the current trigger as a file.

Universal Connection Pool for JDBC Developer's Guide, 11g Release 2 (11.2)

Optimizing Universal Connection Pool Behavior

Setting the Harvest Trigger CountThe connection harvest trigger count specifies the available connection threshold that triggers … connection harvesting. For example, if the connection harvest trigger count is set to 10, then … harvesting by configuring a connection harvest trigger count. pds.setConnectionHarvestTriggerCount(2);

Database Security Guide, 11g Release 2 (11.2)

Using Application Contexts to Retrieve User Information

Creating a Logon Trigger to Run a Database Session Application Context Packageprocedure when he or she logs on. You can create a logon trigger that handles this automatically … logon trigger that executes a PL/SQL procedure. Example 6-4 Creating a Simple Logon Trigger CREATE OR … REPLACE TRIGGER set_empno_ctx_trig AFTER LOGON ON DATABASE BEGIN sec_mgr.set_empno_ctx_proc; END … ; Example

Database Security Guide, 11g Release 2 (11.2)

Verifying Security Access with Auditing

Table 9-5 Comparison of Built-in Auditing and Trigger-Based Auditingstatement is entered. With triggers, an audit record is generated each time a trigger-audited table … generated by a trigger is rolled back if the triggering statement is rolled back. For more … recorded using standard database auditing. In Example 9-26, a trigger audits modifications to the … emp_tab table for specific rows.

SQL*Plus User's Guide and Reference, 11g Release 2 (11.2)

SQL*Plus Error Messages

SP2-0815 Trigger altered with compilation warningsCause: The PL/SQL trigger has been created, but has one or more warnings, informational messages or … performance messages that may help you to improve your PL/SQL trigger. Action: Use the SQL*Plus … SHOW ERR[ORS] command to display the warnings and messages. SP2-0815 Trigger altered with compilation warnings

SQL*Plus User's Guide and Reference, 11g Release 2 (11.2)

SQL*Plus Error Messages

SP2-0814 Trigger created with compilation warnings[ORS] command to display the warnings and messages. SP2-0814 Trigger created with compilation warnings

SQL*Plus User's Guide and Reference, 11g Release 2 (11.2)

SQL*Plus Error Messages

SP2-0837 Trigger created with compilation errors*Plus SHOW ERR[ORS] command to display the warnings and messages. SP2-0837 Trigger created with compilation errors

Streams Concepts and Administration, 11g Release 2 (11.2)

Advanced Apply Process Concepts

Table 10-2 Trigger Firing PropertyTrigger Firing Property User Process Causes Triggering Event Apply Process Causes Triggering Event … Apply Error Execution Causes Triggering Event Always fire Trigger Fires Trigger Fires Trigger Fires … Fire once Trigger Fires Trigger Does Not Fire Trigger Does Not Fire

SQL*Plus User's Guide and Reference, 11g Release 2 (11.2)

SQL*Plus Error Messages

SP2-0838 Trigger altered with compilation errorsCause: The PL/SQL trigger has been created, but has one or more error messages. Action: Use the SQL … *Plus SHOW ERR[ORS] command to display the warnings and messages. SP2-0838 Trigger altered with compilation errors

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

System TriggersA system trigger is created on either a schema or the database. Its triggering event is composed of … \" database_event \" ). A system trigger fires at exactly one of these timing points: Before the … triggering statement runs (The trigger is called a BEFORE statement trigger or statement-level BEFORE … trigger.

Warehouse Builder Installation and Administration Guide, 11g Release 2 (11.2)

Troubleshooting the Installation and Setup

ORA-04088: error during execution of trigger 'DVSYS.DV_BEFORE_DDL_TRG'output for this error: ALTER SYSTEM KILL SESSION '9,29623'; ORA-04088: error during execution of trigger 'DVSYS.DV_BEFORE_DDL_TRG'

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Overview of TriggersLike a stored procedure, a trigger is a named PL/SQL unit that is stored in the database and can be … invoked repeatedly. Unlike a stored procedure, you can enable and disable a trigger, but you cannot … explicitly invoke it. While a trigger is enabled, the database automatically invokes it—that is … , the trigger

Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Types of Parallelism

Trigger Restrictionsbeing operated on, the DML operation is not executed in parallel. Trigger Restrictions A DML

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

INSTEAD OF CREATE TriggersAn INSTEAD OF CREATE trigger is a SCHEMA trigger whose triggering event is a CREATE statement. The … database fires the trigger instead of executing its triggering statement. Example 9-22 shows the … basic syntax for an INSTEAD OF CREATE trigger on the current schema. This trigger fires when the owner

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Conditional Predicates for Detecting Triggering DML StatementThe triggering event of a DML trigger can be composed of multiple triggering statements. When one … of them fires the trigger, the trigger can determine which one by using these conditional predicates … : Conditional Predicate TRUE if and only if: INSERTING An INSERT statement fired the trigger … . UPDATING An

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

DATABASE TriggersA DATABASE trigger is created on the database and fires whenever any database user initiates the … triggering event. Example 9-20 shows the basic syntax for a trigger to log errors. This trigger fires … trigger fires only if Oracle relational database management system (RDBMS) determines that it is safe … SERVERERROR

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

DML TriggersA DML trigger is created on either a table or view, and its triggering event is composed of the DML … statements DELETE, INSERT, and UPDATE. To create a trigger that fires in response to a MERGE … DML trigger is either simple or compound. A simple DML trigger fires at exactly one of these timing … points: Before

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

SCHEMA TriggersA SCHEMA trigger is created on a schema and fires whenever the user who owns it is the current user … DR unit initiates the triggering event of a schema trigger that user2 owns, then that trigger fires … . However, if the DR unit initiates the triggering event of a schema trigger that user1 owns, then … that trigger

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

9 PL/SQL TriggersA trigger is like a stored procedure that Oracle Database invokes automatically whenever a … Subprograms Invoked by Triggers Trigger Compilation, Invalidation, and Recompilation Exception Handling in … Triggers Trigger Design Guidelines Trigger Restrictions Order in Which Triggers Fire Trigger Enabling

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Schema Objects

Enabling TriggersYou enable a disabled trigger using the ALTER TRIGGER statement with the ENABLE option. To enable … the disabled trigger named reorder on the inventory table, enter the following statement: ALTER … TRIGGER reorder ENABLE; To enable all triggers defined for a specific table, use the ALTER TABLE … Language Reference

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Subprograms Invoked by TriggersTriggers can invoke subprograms written in PL/SQL, C, and Java. The trigger in Example 9-9 invokes … a PL/SQL subprogram. The trigger in Example 9-23 invokes a Java subprogram. Example 9-23 TriggerTRIGGER Pre_del_trigger BEFORE DELETE ON Tab FOR EACH ROW CALL Before_delete (:OLD.Id,:OLD.Ename … ); stmt.close();

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Schema Objects

Disabling TriggersConsider temporarily disabling a trigger if one of the following conditions is true: An object that … the trigger references is not available. You must perform a large data load and want it to proceed … quickly without firing triggers. You are loading data into the table to which the trigger applies … . You disable a trigger

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Schema Objects

Enabling and Disabling Triggersexample, you can create a trigger to restrict DML operations against a table, allowing only statements … CREATE TRIGGER statement. They can be defined as firing BEFORE or AFTER the triggering event, or INSTEAD … OF it. The following statement creates a trigger scott.emp_permit_changes on table scott.emp. The … trigger