Instead of trigger in PLSQL Oracle to perform the insert or update on base table rather than on view. To solve the error of cannont modify more than one base table through a join view you can create the instead of trigger.
INSTEAD OF DOING INSERT OR UPDATE ON VIEW PERFORM THE INSERT OR UPDATE ON ACTUAL BASE TABLE.
Error: cannot modify more than one base table through a join view
Solution: Create Instead of Trigger on View
For Learning More about Programming
Subscribe to My Channel: https://www.youtube.com/c/drparagshuk...
On this page of the site you can watch the video online Instead of trigger in PLSQL Oracle (Part-1) - Practical Demo with a duration of hours minute second in good quality, which was uploaded by the user Dr. Parag Shukla 28 September 2022, share the link with friends and acquaintances, this video has already been watched 955 times on youtube and it was liked by 22 viewers. Enjoy your viewing!