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:
![](https://techaid71.xyz/wp-content/uploads/2021/11/System-Trigger-ExampleCreate-Table.jpg)
Step2:
![](https://techaid71.xyz/wp-content/uploads/2021/11/System-Trigger-ExampleBefore-Logging-of-triger.jpg)
Step3:
![](https://techaid71.xyz/wp-content/uploads/2021/11/System-Trigger-ExampleAfter-Logging-on-triger.jpg)
Step4:
![](https://techaid71.xyz/wp-content/uploads/2021/11/System-Trigger-ExampleLogin-Database.jpg)
![](https://techaid71.xyz/wp-content/uploads/2021/11/System-Trigger-ExampleExecute-Trigger.jpg)