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

Answer / prasad

Commit mean if change the values after commit u cont replace
old values.

Rollback mean if u r not given commit u will get previous
values.

Answer / kaushal

Using commit, It saves any modification made within objects of database. We can not undo our transaction which done within commit.
Rollback is similar to undo button of any s/w browser. That is, when we make any changes in recodes of table, we can came back to previous form of that table by using rollback.

Answer / priyanka

COMMIT:Save Record Permanently in database
Syntax :COMMIT;
ROLLBACK: This is like undo
Syntax: ROLLBACK

Answer / ashish kumar

If transaction manager not found any unchecked exception then record is committed.If transaction manager found any unchecked exception then rollback.

What is ABAP query?

2 Answers   TCS,

hi..i hav developed an interactive report in which alv list display in basic list and 1st secondary list in alv grid display.I want to get summation(total) of the columns in the secondary list.I hav used 'do_sum' but i couldnt get.is there any other way to get summation(total) in secondary list which is an alv grid display

0 Answers  

How many secondary indexes can we create in a table?

0 Answers  

Can we create a Table Without a Primary key?

12 Answers   Satyam,

How do you read files from the application server ? : abap bdc

0 Answers  

What are function modules in scripts?

2 Answers  

What are V1 & V2 updates within the SAP LUW? Why & How they occur?

1 Answers  

function modules are also external subroutines. State true or false. : abap modularization

0 Answers  

as a tem leader whats tools u have used in sap

2 Answers   Accenture,

Will the views get effected when updating the database?

3 Answers   Reliance,

component of message and type of message?

2 Answers   TCS,

what is main difference b/w reports and module pool?exact answer?

1 Answers