rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 5th, 2006

 

ROLLBACK:  This is just like UNDO in MSOFFICE but can not  REDO, means what ever changes You made after any commit/rollback or A DDL command they will not be saved into database . when rollback is issued your database goes to the stage when you issued commit/rollback or a DDL command.

example

update emp set sal = 500 + sal;

inser into emp values(.......);

delete from employees where employee_id = 102

rollback;

this rollback will not save changes,  you requested by above dml commands.