How are the DMLs commited in the database triggers internally as they are based on a table and any table commit will commit all the pending transactions which could lead to problems.
I want to know the flow or algorithm of implicit commit of dbtriggers.
ThanksIn Oracle, at least, there is no implicit commit of database triggers. Any DML performed within database triggers forms part of the same transaction as the triggering statement, and all is either committed or rolled back together when the user issues an explicit COMMIT or ROLLBACK.
