Oracle

Advantage of COMMIT and ROLLBACK

Figo Kim 2006. 9. 2. 14:33
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.

With COMMIT and ROLLBACK statements, you can:


  • Ensure data consistency
  • Preview data change before making changes permanent
  • Group logically related operations

UPDATE ...
SAVEPOINT update_done;
Savepoint created.

INSERT ...
ROLLBACK TO update_done;
Rollback complete.


'Oracle' 카테고리의 다른 글

Implicit Transaction Processing  (0) 2006.09.02
Implicit Transaction Processing  (0) 2006.09.02
Advantage of COMMIT and ROLLBACK  (0) 2006.09.02
Database Transactions  (0) 2006.09.02
Database Transactions  (0) 2006.09.02