Trigger to store information of employee into log whenever DML operation performed (Trigger Demo-3)

Опубликовано: 13 Октябрь 2024
на канале: Dr. Parag Shukla
902
27

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