Oracle PL/SQL Trigger in One Video  | Oracle Triggers Tutorial |
Channel: SANTOSH CHOUDHARY
Date: 2020-06-13

TRIGGER :: 
ITS A KIND OF PL/SQL BLOCK , THAT WILL GET EXECUTE AUTOMATICALLY  AFTER OR BEFORE  THE DML OPERATION 
-------------------------
DIFFERENCE BETWEEN PROCEDURE AND TRIGGER :
PROCEDURE | FUNCTION :: ITS PART OF DATABASE | HAS TO EXECUTE 
TRIGGER ::ITS PART OF TABLE (WHEN WE DROP THE TABLE , WILL ALSO DROP THE TRIGGER)  |AUTO EXECUTE 
-------------------------------------
---WHY TRIGGER ?? : IF WE WANT TO PUT CERTAIN RESTRICTIONS OR VALIDATIONS OVER THE  TABLE OR TABLE'S COLUMN 
TYPES OF TRIGGER :: 1. STATEMENT LEVEL TRIGGER 2. ROW LEVEL TRIGGER 
--------------------------------------
---STATEMENT LEVEL : EXECUTE ONCE FOR A STMT 

Enjoy ..Happy Learning ! Getting Started with Oracle Database You can get the Notes on 
My Blog Site : http://santoshagile.blogspot.com/