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


Database SQL Language Reference, 11g Release 1 (11.1)

DROP TRIGGER

DROP TRIGGERReference for complete information on creating, altering, and dropping triggers. Use the DROP TRIGGER … statement to remove a database trigger from the database. 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

Database SQL Language Reference, 11g Release 1 (11.1)

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. Prerequisites To create a trigger in your own schema on a table in your own schema or on your

Database SQL Language Reference, 11g Release 1 (11.1)

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 1 (11.1)

Using Triggers

Trigger StatesA trigger can be in either of two states: Enabled. An enabled trigger executes its trigger body if … a triggering statement is entered and the trigger restriction (if any) evaluates to TRUE.

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Triggers

Trigger TypesA DML trigger is fired by a DML statement, a DDL trigger is fired by a DDL statement, a DELETE … trigger is fired by a DELETE statement, and so on. An INSTEAD OF trigger is a DML trigger that is … defined on a view (not a table). The database fires the INSTEAD OF trigger instead of executing

Database PL/SQL Language Reference, 11g Release 1 (11.1)

ALTER TRIGGER Statement

ALTER TRIGGER StatementThe ALTER TRIGGER statement enables, disables, or compiles 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. Prerequisites The trigger

Database PL/SQL Language Reference, 11g Release 1 (11.1)

CREATE TRIGGER Statement

CREATE TRIGGER StatementThe CREATE TRIGGER statement creates or replaces a database trigger, which is either of the … trigger when specified conditions occur. Order of Trigger Firing  If two or more triggers with different … triggers with different timing points with a single compound trigger that explicitly codes the actions

Database PL/SQL Language Reference, 11g Release 1 (11.1)

DROP TRIGGER Statement

DROP TRIGGER StatementThe DROP TRIGGER statement drops a database trigger from the database. 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 in another user's schema, you must also have the ADMINISTER DATABASE TRIGGER

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Triggers

Examples of Trigger Applicationsthese trigger applications. These examples are not meant to be used exactly as written: They are provided to assist you in designing your own triggers.

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Triggers

Who Uses the Trigger?Maximum Trigger Size The size of a trigger cannot be more than 32K. SQL Statements Allowed in … Trigger Bodies A trigger body can contain SELECT INTO statements, SELECT statements in cursor definitions … , and all other DML statements. A system trigger body can contain the DDL statements CREATE TABLE

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Triggers

Coding the Trigger BodyNote: This topic applies primarily to simple triggers. The body of a compound trigger has a … different format (see Compound Triggers ). The trigger body is either a CALL subprogram (a PL/SQL … and if the trigger restriction (if any) evaluates to TRUE. If the trigger body for a row trigger is

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Triggers

When Does the Trigger Fire?A trigger fires based on a triggering statement, which specifies:

Database SQL Language Reference, 11g Release 1 (11.1)

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 1 (11.1)

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 Concepts, 11g Release 1 (11.1)

Triggers

Trigger RestrictionA trigger restriction specifies a Boolean expression that must be true for the trigger to fire. The … trigger action is not run if the trigger restriction evaluates to false or unknown. In the example … , the trigger restriction is: new.parts_on_hand Consequently, the trigger does not

Database Concepts, 11g Release 1 (11.1)

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.

Database Concepts, 11g Release 1 (11.1)

Triggers

Trigger ExecutionA trigger is either enabled or disabled. Table 22-1 Trigger Modes Trigger Mode Definition Enabled … An enabled trigger runs its trigger action if a triggering statement is issued and the trigger … restriction (if any) evaluates to true. Disabled A disabled trigger does

Database Performance Tuning Guide, 11g Release 1 (11.1)

Using Application Tracing Tools

21.5.5 Avoiding the Trigger Trapwas being processed. Therefore, they include any resources used within a trigger, along with the

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Resumable Space Allocation

Notifying Users: The AFTER SUSPEND System Event and Triggerlevel. If a user registers a trigger to handle this system event, the trigger is executed after a SQL … statement has been suspended. SQL statements executed within a AFTER SUSPEND trigger are always non … -resumable and are always autonomous. Transactions started within the trigger use the SYSTEM rollback … segment.

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Resumable Space Allocation

Using a LOGON Trigger to Set Default Resumable ModeUSER_RESUMABLE views. Using a LOGON Trigger to Set Default Resumable Mode Another method of setting … can register a database level LOGON trigger to alter a user's session to enable resumable and set a … timeout for resumable statements, the result will be unspecified because Oracle Database does not guarantee the order of trigger invocation.