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:    • Tutorial#1 Basics Of Oracle SQL for Beginn...   follow me on: Facebook Page: https://www.facebook.com/Equalconnect...   / equalconnect     / lrnwthr