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

Explain “commit” and “roll back” commands?

Answer Posted / Franklin Eric Kujur

In SAP HANA, the COMMIT and ROLLBACK commands are used to manage database transactions.

1) COMMIT: This command finalizes all changes made during a transaction by saving the data to the database. The basic syntax for the COMMIT command is:
COMMIT WORK;

2) ROLLBACK: This command undoes all changes made during a transaction and discards them. In other words, it restores the database to its state before the transaction began. The basic syntax for the ROLLBACK command is:
ROLLBACK WORK;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category