2017  Kodetalk | Feedback | Privacy Policy | Terms | About
userimage

commit will execute before trigger statement executes?

I created a trigger which will insert a record in test1 table if i update any record test_base table.

Here i written a query to update the test_base  and commited it.

Now the commit will wait until trigger event was done or it will be commited before the trigger event.

Please let me know

userimage

Commit will wait until the trigger event is completed.

First updated statement called through that internally insert is called.

Next we will commit;

Answer is