Noel

• Jul 17th, 2012

 

No. Triggers run as part of transaction. In Oracle you can create an autonomous transaction inside of a trigger if you really need one.

Rpradeep

 Profile Answers by Rpradeep Questions by Rpradeep

• Jul 7th, 2014

 

Yes we can use commit or rollback statements in trigger by using AUTONOMOUS_TRANSACTION pragma.

Rakesh057

 Profile Answers by Rakesh057 Questions by Rakesh057

• Jul 19th, 2014

 

NO.. triggers are auto commit no need of commit or rollback