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
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 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
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
Using a LOGON Trigger to Set Default Resumable Mode → initialization parameter, is that you can register a database level LOGON trigger to alter a user's session … Oracle Database does not guarantee the order of trigger invocation.
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
Resumable Space Allocation Example: Registering an AFTER SUSPEND Trigger → In the following example, a system wide AFTER SUSPEND trigger is created and registered as user SYS … at the database level. Whenever a resumable statement is suspended in any session, this trigger can … interval is reset to 8 hours. Here are the statements for this example: CREATE OR REPLACE TRIGGER … resumable_default AFTER
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.
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.
ASSIGN → Specifies that Oracle OLAP executes the specified program in response to an 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