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


Objects for OLE, 9i Release 2 (9.2.0.2)

Trigger Methods

Trigger MethodsMaster Index Feedback Trigger Methods PostAdd PostDelete PostMove PostQuery PostRollback PostUpdate

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: ALTER TRIGGER to COMMIT, 2 of 11

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

Concepts, 9i Release 2 (9.2.0.2)

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

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 6 of 19

DROP TRIGGERPurpose Use the DROP TRIGGER statement to remove a database trigger from the database. See Also … : CREATE TRIGGER for information on creating triggers ALTER TRIGGER for information on enabling, disabling, and compiling triggers

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE SYNONYM to CREATE TRIGGER, 6 of 6

CREATE TRIGGERPurpose Use the CREATE TRIGGER statement to create and enable a database trigger, which is A stored … call to a procedure implemented in PL/SQL or Java Oracle automatically executes a trigger when … specified conditions occur. When you create a trigger, Oracle enables it automatically. You can … subsequently disable

Concepts, 9i Release 2 (9.2.0.2)

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.

Concepts, 9i Release 2 (9.2.0.2)

Triggers

Trigger ExecutionA trigger is in either of two distinct 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 not run its trigger

Objects for OLE, 9i Release 2 (9.2.0.2)

PreUpdate Trigger Method

PreUpdate Trigger MethodMaster Index Feedback PreUpdate Trigger Method Applies To OBinder OBound Description Called before a … PreUpdate trigger does nothing. The default OBinder PreUpdate trigger does nothing.   Copyright

Objects for OLE, 9i Release 2 (9.2.0.2)

PostDelete Trigger Method

PostDelete Trigger MethodMaster Index Feedback PostDelete Trigger Method Applies To OBinder OBound Description Called after a … trigger does nothing. The default OBinder PostDelete trigger does nothing.   Copyright © 1998, 2002

Objects for OLE, 9i Release 2 (9.2.0.2)

PostAdd Trigger Method

PostAdd Trigger MethodMaster Index Feedback PostAdd Trigger Method Applies To OBinder OBound Description Called after a … new record is added Usage virtual oresult PostAdd (void) Remarks The default OBound PostAdd trigger … will refresh the value of the OBound. The default OBinder PostAdd trigger does nothing. Adding a

Objects for OLE, 9i Release 2 (9.2.0.2)

PreMove Trigger Method

PreMove Trigger MethodMaster Index Feedback PreMove Trigger Method Applies To OBinder OBound Description Called before … trigger does nothing. The default OBinder PreMove trigger saves to the database any changes to the current

Objects for OLE, 9i Release 2 (9.2.0.2)

PreRollback Trigger Method

PreRollback Trigger MethodMaster Index Feedback PreRollback Trigger Method Applies To OBinder OBound Description Called before … trigger does nothing. The default OBinder PreRollback trigger does nothing.   Copyright © 1998, 2002

Objects for OLE, 9i Release 2 (9.2.0.2)

Startup Trigger Method

Startup Trigger MethodMaster Index Feedback Startup Trigger Method Applies To OBinder OBound Description Called when the … object binding starts. OBinder: This trigger method is called at the time the first bound object is … : This trigger method is called immediately after a bound object is bound to a binder. If the binder has … (usually the case)

Objects for OLE, 9i Release 2 (9.2.0.2)

Shutdown Trigger Method

Shutdown Trigger MethodMaster Index Feedback Shutdown Trigger Method Applies To OBinder OBound Description Called when the … The default OBound Shutdown trigger does nothing. The default OBinder Shutdown trigger saves to the

Objects for OLE, 9i Release 2 (9.2.0.2)

PostQuery Trigger Method

PostQuery Trigger MethodMaster Index Feedback PostQuery Trigger Method Applies To OBinder OBound Description Called after an … PostQuery trigger will refresh the value of the OBound. The default OBinder PostQuery trigger does

Objects for OLE, 9i Release 2 (9.2.0.2)

PreDelete Trigger Method

PreDelete Trigger MethodMaster Index Feedback PreDelete Trigger Method Applies To OBinder OBound Description Called before a … trigger does nothing. The default OBinder PreDelete trigger does nothing.   Copyright © 1998, 2002

Objects for OLE, 9i Release 2 (9.2.0.2)

PostRollback Trigger Method

PostRollback Trigger MethodMaster Index Feedback PostRollback Trigger Method Applies To OBinder OBound Description Called after … PostRollback will refresh the value of the OBound. The default OBinder PostRollback trigger does nothing

Objects for OLE, 9i Release 2 (9.2.0.2)

PreQuery Trigger Method

PreQuery Trigger MethodMaster Index Feedback PreQuery Trigger Method Applies To OBinder OBound Description Called before an … trigger does nothing. The default OBinder PreQuery trigger does nothing.   Copyright © 1998, 2002

Objects for OLE, 9i Release 2 (9.2.0.2)

PostMove Trigger Method

PostMove Trigger MethodMaster Index Feedback PostMove Trigger Method Applies To OBinder OBound Description Called after … trigger will refresh the value of the OBound. The default OBinder PostMove trigger does nothing

Objects for OLE, 9i Release 2 (9.2.0.2)

PreAdd Trigger Method

PreAdd Trigger MethodMaster Index Feedback PreAdd Trigger Method Applies To OBinder OBound Description Called before a … new record is added OBinder: This trigger method is called before a new record is added. By default … updates the record (which as a side effect calls the update triggers). OBound: This trigger method … OBound PreAdd trigger