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


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)

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)

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)

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

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.

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