Instead of trigger in PLSQL Oracle (Part-1) - Practical Demo
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...
