plsql Tutorial#20 trigger in oracle | DML Trigger |pl sql triggers in oracle database

Published: 04 October 2020
on channel: EqualConnect Coach

5,661

105

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 B...

follow me on:
Facebook Page:
https://www.facebook.com/Equalconnect...
  / equalconnect
  / lrnwthr

Watch video plsql Tutorial#20 trigger in oracle | DML Trigger |pl sql triggers in oracle database online without registration, duration hours minute second in high quality. This video was added by user EqualConnect Coach 04 October 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,661 once and liked it 105 people.

5,082