Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between commit and rollback.?
- 5 Answers
- 33620 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 do you set up background jobs in sap? What are the steps? What are the events driven batch jobs?
What is direct input method ?
What is client in the sap system? : sap abap hr
What is meant by hide area?
Difference between .Include and .append?
Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.
How to combine multiple order in one Delivery ( Step by Step)?
What is the use of f4if_shlp_exit_example function module ? : sap abap data dictionary
where do we store all custom programs in SD module?
Some Realtime Examples on Exits .
What are critical issues you have faced in your project
How many types of tables exist and what are they in data dictionary?
Why cant we use Normal function module for data transfer?
Define database layer?
How many main windows will be there in a page window?
