How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
DELETE → Specifies that the trigger for the program is a Delete event. A Delete event is a DELETE statement
ALTER TRIGGER → Purpose 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
Restrictions on Trigger Conditions → If 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
DELETE ALL → Deletes 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
Restrictions on BEFORE Triggers → You 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.
Restrictions on Triggers on UPDATE Operations → You 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
TRIGGER command → The 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.
UPDATE → TRIGGER_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.
NAME → For 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
CREATE TRIGGER → Purpose 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
ASSIGN → Specifies 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
DROP TRIGGER → Purpose 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
TRIGGER function → The 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
Restrictions on Trigger Implementation → The 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
MAINTAIN → Specifies that the trigger for the program is a Maintain event. A Maintain event is the execution
DELETE event-name → Deletes the triggers for the specified object events. Oracle OLAP disassociates the trigger program from the specified object event.
Restrictions on AFTER Triggers → You 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
PROPERTY → Specifies 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.
Restrictions on INSTEAD OF Triggers → INSTEAD 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
Trigger Action → A 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.