Скачать или смотреть [SQL] View for Audit Table filled via Trigger

This video is a direct follow-up of the video "[SQL] Trigger to track Update, Insert, Delete".

We had made a trigger to capture the before and after values of columns affected by an update, insert, delete. These values were saved in an audit table, but scrolling across, when what truly changed, could be difficult.

This view makes it easy, putting all old values in one column, and all new values in another column.
Note: After the recording, I did comment out the OLD_TIMESTAMP and NEW_TIMESTAMP columns because we had the SYS_DATE value.

🔴 IF YOU WANT THE CODE: 🔴
Go to our GitHub at https://github.com/VeeBeeCoding/YouTu....
The file name will match the YouTube title name for the corresponding video.

🔗 Other Links
Instagram -   / veebeecoding  
Ko-fi - https://ko-fi.com/veebeecoding

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\

🖐Hi! I'm VeeBee, you can call me VB or Bee for short! Over the years during my career I have been keeping a journal of what I have learned when working in different languages and projects.

🏁 My goal is to pass along what I have learned to you by teaching through projects and exercises based on real world experiences.

✨ My promise to you is that I will do my best to not waste time. Each video will have a full summary at the very beginning so that you can determine if you can skip the video if you already know the material, or the summary can be a refresher if you're coming back.

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\

☕ If you found this tutorial helpful and would like to spot me a coffee as thanks, please consider leaving a small tip or donation on my Ko-Fi site at https://ko-fi.com/veebeecoding.
Tips are never expected, but always appreciated! I plan on creating content regardless, so there is no pressure or obligation to donate.