New Database triggers : Database Level Trigger « Trigger « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Trigger
  3. Database Level Trigger
SQL> CREATE OR REPLACE TRIGGER On_Logon
  2  AFTER LOGON
  3  ON SCHEMA
  4  BEGIN
  5    DBMS_UTILITY.ANALYZE_SCHEMA(sys.login_user,'ESTIMATE');
  6  END;
  7  /

Trigger created.

SQL>
SQL> drop trigger On_Logon;

Trigger dropped.








28.14.Database Level Trigger
28.14.1.Database level trigger: AFTER STARTUP ON DATABASE
28.14.2.Database level trigger: BEFORE SHUTDOWN ON DATABASE
28.14.3.New Database triggers
28.14.4.Database logon trigger
28.14.5.Database logoff trigger
28.14.6.Save information about all errors in an after-servererror on database