locking

hi gurus
can u pls explain the differences b/w or meanings of:-
promotional locking
optimistic locking
pessimistic locking

Regards

You should find this entry from the Oracle documentation useful:

"How to choose the locking Technique"

http://otn.oracle.com/docs/products/...dv.htm#1003124

Regards