How to commit in a trigger | Oracle PL SQL

This video is a free video tutorial on how to commit or rollback in a pl/sql trigger, it demonstrates the use of pragma autonomous_transaction and commit in a trigger, also it shows various scenarios which would lead to misleading data and exceptions that would be raised if pragma autonomous_transaction is not properly used in the trigger.

Other Playlists:

Content and video created by : Kishan Mashru

[YogeshBiguvu]

Very good explanation...thanks a lot..

[vallimuthaiyah]

very useful video on triggers😀 thanks a lot Kishan.. this is something that we come across in day to day coding standards of plsql.. looking forward for more videos on performance tuning topics please 😀

[shaheenshaikh]

Thanks a ton sir for such a gr8 video !!! I have a question like when to use before and after in trigger im confused in that plz help !! Thanks .

[debadyutibal]

Nice explanations dude, Thanks... Can u make videos on 'serially reusable pragma' and other pragmas in PLSQL except autonomous and exception_init.

[prasadtamminana]

hi bro ur explanation is godd but why u have declared p_error_code, p_error_msg inte trigger declaration part