Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between commit and rollback.?
- 5 Answers
- 33821 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
What is internal payroll process? : sap abap hr
How to Solve a Particular Ticket in Realtime ?
What is the role of ‘refresh’ in internal table?
what is code to upload cost centers through call trans. and procedure
What is technically difference between in Table creation in table creation maintenance not allowed ,maintenance allowed with restriction, maintenance allowed ?
What are the function of the transport system and workbench organiser? : abap data dictionary
How many ways you can create table? : abap data dictionary
What is the difference between a pool table and a transparent table and how they are stored at the database level?
Which database object is used for storing the system variables? : abap data dictionary
Can i have some Realtime Scenarios on Reports.
while implementing badi what are the tables u find??
What is database utility? : abap data dictionary
What are the check tables and value tables?
When value table becomes check table?
What are the different function modules used in sapscript?
