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 O...
follow me on:
Facebook Page:
www.facebook.c...
/ equalconnect
/ lrnwthr

[@aliemansaray7707]

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

[@_One_-ul9vb]

l learnt so much from your series 🧡🧡

[@jhjaniya]

I learnt very well from this.

[@saindad791]

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

[@jhjaniya]

Amazing content.

[@vadlakuntanaveen1377]

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

[@devenderkumar200]

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

[@SivaNanda-i4n]

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.

[@EqualConnectCoach]

Yes I am to restart

[@sivanandareddy-er7bx]

Good 👍😊

[@pythonically]

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

[@EqualConnectCoach]

@pythonically I think u r trying create trigger which is came as part of oracle installation

[@computerlearningbyargusaca5217]

Amazing

[@vadlakuntanaveen1377]

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

[@EqualConnectCoach]

Yes

[@galymzhanmakhaliev5392]

okay!

[@magragirma8695]

send me all ppt