Trigger to store information of employee into log whenever DML operation performed (Trigger Demo-3)
WRITE LOG TRIGGER ON EMPLOYEE TABLE AND COLLECT THE FOLLOWING INFORMATION OF THE PERSON WHO HAS PERFORMED ANY TRANSACTION ON EMP TABLE
USERNAME, DATE, TRANSTYPE (INSERT, UPDATE, DELETE), OLDEMPNO,NEWEMPNO, OLDNAME, NEWNAME, OLDJOB, NEWJOB, OLDSAL, NEWSAL
For Learning More about Programming
Subscribe to My Channel: https://www.youtube.com/c/drparagshuk...
