ANSI SQL

NAVIGATION
CATEGORIES
REFERRENCE
LINKS
  • Database triggers

    1 answers - 278 bytes - related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

    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.
    Thanks
  • No.1 | | 283 bytes | |

    In 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.

Re: Database triggers


max 4000 letters.
Your nickname that display:
In order to stop the spam: 8 + 7 =
QUESTION ON "ANSI SQL"

DATABASE TECH