Oracle SQL beginner tutorials With exercise/ Database Basic to Advance Training - plsql Tutorial#20 trigger in oracle | DML Trigger |pl sql triggers in oracle database

In this pl sql trigger tutorial, we are going to learn a DML trigger in the 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 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 happen in 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 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