Pradeep

• Oct 26th, 2006

 

Database triggers are executed in response to particular events on tables in a databaseSchema triggers are fired when schema objects (tables) are modified. It can be like before create, later,drop

srietl

 Profile Answers by srietl 

• Oct 30th, 2006

 

May be the question is like this 'Whats the diff. between database triggers on database or schema?

Database triggers can be system triggers on a database or a schema.

With a database,triggers  fire for each event for all users...

With a schema,triggers fire for each event for that specific user...

srujan

• Oct 30th, 2006

 

May be the question is like this...

What database triggers on a database or on a schema?

With a database,triggers fire for each event for all users.

With a schema,triggers fire for each event for that specific user. 

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 5th, 2006

 

In database trigger:  Trigger for a table /view  is a database trigger

like ( before , insert  * update, delete, insert * row level, statement level)

2 * 3 * 2 = 12  + instead off trigger for views

schema triggers reffers to :  before logoff, after logon, before create, drop,alter on schema ( these trigger are also called DDL trigger)

Application trigger:  before shutdown, after startup, on error( any error occur in database, after starting the orcalce instance, before closing the instance)

g_sidhu

 Profile 

• Feb 18th, 2008

 

Triggers on system events can be defined at the database or schema level.

A trigger defined at the database level fires for all users, and 

A trigger defined at the schema or table level fires only when the triggering event involves that schema or table.