• Product Information
  • About
  • Product tour
  • News
  • Screenshots
  • Testimonials
• Support Information
  • Documentation
  • FAQ
  • Support
  • Upgrade policy
• Download
• Purchase

Download Buy

Oracle Maestro online help

Editing trigger properties

Schema Trigger Editor provides you with an ability to edit trigger properties. The Properties tab allows you to change the trigger name, the trigger events.

The Errors tab displays all the necessary information about object errors. If an error have occurred during the object compilation it appears in the list with some additional properties: Order (one after another), Line and Position (object definition location the error was found out), Error (corresponding PL/SQL exception).

The Definition field contains the definition of the schema trigger.

Name

Here you can view and change the trigger name.
 

Note: the name of the object must be unique among all the object names in its container. Moreover, all the objects that are source of data need unique names among themselves. You can use any identifier that is allowed by Oracle server.

Owner

There is the owner for the trigger.

Enabled

Check the option to enable the trigger.

When fire (Before, After)

Specify Before to cause the database to fire the trigger before executing the triggering event. For row triggers, the trigger is fired before each affected row is changed. 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.

When condition

Specify the trigger condition, which is a SQL condition that must be satisfied for the database to fire the trigger.

Specify the Schema name to define the trigger on the current schema. The trigger fires whenever any user connected as schema initiates the triggering event.

alter

Specify alter to fire the trigger whenever an ALTER statement modifies a database object in the data dictionary.

analyze

Specify analyze to fire the trigger whenever the database collects or deletes statistics or validates the structure of a database object.

associate statistic

Specify ASSOCIATE STATISTICS to fire the trigger whenever the database associates a statistics type with a database object.

audit

Specify audit to fire the trigger whenever the database tracks the occurrence of a SQL statement or tracks operations on a schema object.

comment

Specify comment to fire the trigger whenever a comment on a database object is added to the data dictionary.

create

Specify create to fire the trigger whenever a CREATE statement adds a new database object to the data dictionary.

diassociate statistic

Specify diassociate statistic to fire the trigger whenever the database disassociates a statistics type from a database object.

drop

Specify drop to fire the trigger whenever a DROP statement removes a database object from the data dictionary.

grant

Specify grant to fire the trigger whenever a user grants system privileges or roles or object privileges to another user or to a role.

no audit

Specify no audit to fire the trigger whenever a no audit statement instructs the database to stop tracking a SQL statement or operations on a schema object.

rename

Specify rename to fire the trigger whenever a rename statement changes the name of a database object.

revoke

Specify revoke to fire the trigger whenever a revoke statement removes system privileges or roles or object privileges from a user or role.

truncate

Specify truncate to fire the trigger whenever a truncate statement removes the rows from a table or cluster and resets its storage characteristics.

DDL

Specify DDL to fire the trigger whenever any of the preceding DDL statements is issued.

To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.

It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.