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

Can i use Commit inside the Trigger? Suppose i use commit
what will be happy (it's complied /executed/work)

Answer Posted / swapna

commit,rollback and savepoint cannot be used in a trigger
directly, but it can be called in a stored procedure
present in the trigger. however it is usually avoided as it
might have sideeffects in transactions.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Advantages and disadvantages of stored procedure?

1118


What is #table in sql?

1083


Can unique keys be null?

898


How to download oracle sql developer?

1096


What is the use of <> sql?

970


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1060


Does access use sql?

1031


Why do we use triggers?

963


What are the features of pl sql?

1060


What are the advantages of sql?

1051


Why do you partition data?

1016


explain the difference between bool, tinyint and bit. : Sql dba

987


What are the sql versions?

935


What does partition by mean in sql?

955


What does varchar include?

942