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:

System Trigger ExampleCreate Table

Step2:

System Trigger ExampleBefore Logging of triger

Step3:

System Trigger ExampleAfter Logging on triger

Step4:

System Trigger ExampleLogin Database
Step5:
System Trigger ExampleExecute Trigger

About the author

shohal

Leave a Comment