Can anybody enlighten me regarding the difference between an SX-sub exclusive lock and X-exclusive lock. How do you get such lock. If I'm just doing a select (w/o for update) is it possible to have this two mode of lock?

thx

Ed