- 論壇徽章:
- 0
|
請教savepoint的問題
在看savepoint的解釋的時候,對ON ROLLBACK RETAIN CURSORS和ON ROLLBACK RETAIN LOCKS不是很明白,這兩個之間有什么區(qū)別?
另外,對這兩個的解釋也沒看明白,不知道其英文到底想表達(dá)什么,每個詞都能看懂,就是不理解:
ON ROLLBACK RETAIN CURSORS
Specifies system behavior upon rollback to this savepoint with respect to
open cursor statements processed after the SAVEPOINT statement. The
RETAIN CURSORS clause indicates that, whenever possible, the cursors
are unchanged by a rollback to savepoint. For situations where the cursors
are affected by the rollback to savepoint, see “ROLLBACK”.
ON ROLLBACK RETAIN LOCKS
Specifies system behavior upon rollback to this savepoint with respect to
locks acquired after the setting of the savepoint. Locks acquired since the
savepoint are not tracked and are not rolled back (released) on rollback to
the savepoint. |
|