Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between commit and rollback.?
- 5 Answers
- 33360 Views
- Cognizant, Patni, I also Faced
- E-Mail Answers
Answer Posted / malli.gontla
suppose u have one table which is in database. The table
contains some records. U want to modify one record of table.
after modification, u don't want that new values for
the record. just u use rollback command. previous values are
placed in database.
Example:
Case 1: Roll Back
sno name palce
1 abc hyderabad
2 xyz bangalore.
This is the table and it contains some records.
Suppose if u want change the 2nd record, means palce
is changed to chennai.
After modification:
sno name palce
1 abc hyderabad
2 xyz Chennai.
Suppose if u want old values, means u don't want new
values. At that time u use roll back command
After useing rollback:
sno name palce
1 abc hyderabad
2 xyz bangalore.
after using roll back, the records are comes like
above(original records)
Case 2: Commit
sno name palce
1 abc hyderabad
2 xyz bangalore.
This is the table and it contains some records.
Suppose if u want change the 2nd record, means palce
is changed to chennai.
After modification:
sno name palce
1 abc hyderabad
2 xyz Chennai.
After useing commit:
sno name palce
1 abc hyderabad
2 xyz Chennai.
after using commit, the table is finilased.u can't get
old values by uisng roll back.
Once if u use commit,u can't get old values for using of
rollback. Before commit, u can get old values for rollback.
| Is This Answer Correct ? | 112 Yes | 4 No |
Post New Answer View All Answers
Write special commands of list?
What are the aggregate objects in the data dictionary? : abap data dictionary
How to read files and process BDC's automatically ?
A field containing quantity amounts (data type quan) must be assigned to a reference table and a reference field. Explain? : abap data dictionary
What is img? : sap abap hr
In which particular scenario we use sorted table and which particular scenario we use standard table?
What are the steps in a bdc session? : abap bdc
What is the t-code for transaction recorder? : abap bdc
What are the different types of mode (run code) in call transaction method?
Sal abap on hana interview
what is the process of creating quotation using BAPIs.
How to copy table across clients?
What is a variable in the sap abap?
What is the use of info groups? : sap abap hr
How to do find it?
