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
DROP TRIGGER → Reference 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
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. Prerequisites To create a trigger in your own schema on a table in your own schema or on your
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
Trigger States → A 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.
Trigger Types → A 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
ALTER TRIGGER Statement → The 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
CREATE TRIGGER Statement → The 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
DROP TRIGGER Statement → The 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
Examples of Trigger Applications → these trigger applications. These examples are not meant to be used exactly as written: They are provided to assist you in designing your own 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
Coding the Trigger Body → Note: 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
When Does the Trigger Fire? → A trigger fires based on a triggering statement, which specifies:
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
Trigger Restriction → A 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
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.
Trigger Execution → A 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
21.5.5 Avoiding the Trigger Trap → was being processed. Therefore, they include any resources used within a trigger, along with the
Notifying Users: The AFTER SUSPEND System Event and Trigger → level. 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.
Using a LOGON Trigger to Set Default Resumable Mode → USER_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.