Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?

Answer Posted / deva

yes we cannot make TCL commands with in triggers. If the
block is declared as a autonomous transaction, then commit
and rollback can be given in the end of the block

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to select all records from the table?

1136


What are stored procedures in mysql?

1019


What is sql and its types?

1192


Can we join 3 tables in sql?

1044


Which join is like inner join?

1028


Explain locks? : Transact sql

1010


What is the limitation on the block size of pl/sql?

987


what is bdb (berkeleydb)? : Sql dba

1035


what are wild cards used in database for pattern matching ? : Sql dba

1144


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1064


What is function and procedure?

1033


What is the difference between inner join and left join?

989


What are the two types of periodical indexes?

940


What is foreign key in sql with example?

937


What is the maximum number of rows in sql table?

1030