Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between commit and rollback.?
- 5 Answers
- 33416 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
How to convert normal function module to bapi?
What is personnel sub are
How do you find number of records present in internal table?
What are the types of the software component being deployed in the sap?
What are the different abap/4 editors?
What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why? : abap modularization
What is the difference between a dialog program and a report?
What is the use of 'table index'?
List some of the many different ways that the sap standard functionality can be changed by a customer?
Differentiate between the uline and write: sy-uline statements if any?
Can you print decimals in type n? What is difference between float and packed data type?
What is an authorization in sap?
Explain what is the step-by-step process to create a table in data dictionary?
Why is pretty printer user in abap?
What is buffering allowed but switched off?
