Database Trigger « Trigger « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Trigger
  3. Database Trigger
1.Trigger for database startup event
2.Trigger to log the database shutdown
3.Logon trigger
4.After logon database trigger
5.Log database logon to a table
6.Log a server error to a table
7.Log a server error with information on time, user name, database name
8.A system trigger(AFTER CREATE ON DATABASE) .
9.creating a logon/logoff auditing system using system-level triggers:




10.Save information about all errors in an after-servererror on database
11.Submit a job for altering user in an after-create-database trigger