pl sql tutorial#19 Introduction of PLSQL Trigger in oracle database

In this pl SQL tutorial, we are going to learn pl sql trigger in oracle database

What is trigger in the PLSQL database?
Triggers are stored programs, which are automatically executed
when some events (activity) occurs, event/activity can delete record,
update record creates the table, login database etc.


Types of trigger
1) DML Triggers
- Normal DML trigger
- INSTEAD OF Triggers
2) DDL trigger
3) DATABASE operation Triggers


DML Triggers :
If any DELETE, INSERT, or UPDATE operation happens in the database and you wanted
to automatically trigger/invoke some store program then it is called DML Triggers


DATABASE operation Triggers :
If any LOGON/LOGOFF/STARTUP/SHUTDOWN operation happen in the database and you wanted to
automatically trigger/invoke some store program then it is called DDL Triggers

What DDL trigger :
If any CREATE, ALTER, or DROP operation happen in database and you wanted to automatically
trigger/invoke some store program then it is called DDL Triggers

INSTEAD OF CREATE Triggers :
When you issue a DML statement such as INSERT, UPDATE, or DELETE to a non-updatable view,
Oracle will issue an error

Oracle SQL Complete Tutorial/Training/Course for the beginner:
https://www.youtube.com/watch?v=3v4s3XMw4q0&list=PLiLpmqwkwkCt0QeXD8j7BwIoOaBGBRrZC


follow me on:
Facebook Page:
https://www.facebook.com/Equalconnect-Coach-791404517889358/?modal=admin_todo_tour
https://www.instagram.com/equalconnect/
https://twitter.com/LrnWthR