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

What is data control language (dcl)?

1042


What is the difference between a database and a relational database?

1034


What are the advantages of sql? Explain

1049


How would you convert date into julian date format?

946


Write a unique difference between a function and a stored procedure.

924


What is the best free sql database?

998


How can you view the errors encountered in a trigger?

915


What are triggers in sql?

971


Explain what is dbms?

985


What can sql server reporting services do?

1052


What is a sql profiler?

960


What is a trigger in sql?

1156


What is the purpose of normalization?

995


what is the bond code in materialized view?

2930


What is sql trigger example?

997