EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

DB and Schema Triggers


A database trigger is:

  • a stored PL/SQL block associated with a schema, or the database or
  • an anonymous PL/SQL block or a call to a procedure implemented in PL/SQL or Java

Oracle automatically executes a trigger when specified conditions occur.

 

DB/Schema Trigger Editor allows you to define database and schema trigger properties. It opens automatically when you create a new database or schema trigger and is available on editing an existing one.

 

To open a database or schema trigger in DB/Schema Trigger Editor, double-click it in the DB Explorer tree.