Saturday 26 May 2012

Can a COMMIT statement be executed as part of a trigger? | PL SQL

 No, A COMMIT statement cannot be executed as a part of a trigger because it is a Transaction Control statement, which cannot be executed within a trigger body. Triggers fire within transactions and cannot include any Transaction Control statement within its code.