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:

follow me on:
Facebook Page:

[aliemansaray]

Great lessons. Thank you so much for your insights. I enjoy your teachings.

[SivaNanda-in]

hi bro, since 2 years no updates from you.
how are you?
hope you are doing good,
i thank you so much for your plsql videos.

[vadlakuntanaveen]

what will happen when alter and update keywords in same query.what type of trigger we should use

[saindad]

sir purpose of replace and the difference between before and after couldn't understand

[devenderkumar]

What is the data in Schema_audit statement?
You not show schema_audit program and directly run this statement

[pythonically]

error: what is meant by this why I get this error while compiling trigger "cannot create triggers on objects owned by SYS"

[vadlakuntanaveen]

is it possible to create two or more triggers for ane table