Oracle SQL,PL/SQL

What is system trigger?

System Trigger PL/SQL
Written by shohal

System Trigger fires when a system event like database startup, shutdown or DDL operations like creating objects occur in oracle database. System triggers wont fire for DML operation.

It will show (work) Login and Logoff Seniority .

Example:

Step1:

Step2:

Step3:

Step4:

Step5:

About the author

shohal

Leave a Comment