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
Trigger Restrictions → these 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
DROP TRIGGER Statement → The 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
CREATE TRIGGER Statement → The 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
ALTER TRIGGER Statement → The 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
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
Trigger Enabling and Disabling → By 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
Trigger Changing and Debugging → To 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
Trigger Size Restriction → The 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\".
Trigger Compilation, Invalidation, and Recompilation → The 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
Trigger LONG and LONG RAW Data Type Restrictions → RAW 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
ALTER TRIGGER → 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 TRIGGER
DROP TRIGGER → complete 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
CREATE TRIGGER → the 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
trigger → A 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.
System Triggers → A 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.
Overview of Triggers → Like 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
16 SQL Statements: CREATE SYNONYM to CREATE TRIGGER → This chapter contains the following SQL statements: CREATE SYNONYM CREATE TABLE CREATE TABLESPACE CREATE TRIGGER
13 SQL Statements: ALTER TRIGGER to COMMIT → This chapter contains the following SQL statements: ALTER TRIGGER ALTER TYPE ALTER USER ALTER VIEW ANALYZE ASSOCIATE STATISTICS AUDIT CALL COMMENT COMMIT
INSTEAD OF CREATE Triggers → An 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
Conditional Predicates for Detecting Triggering DML Statement → The 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