It seems that the query like SELECT DISTINCT oid FROM table1 FOR UPDATE does not work. I chcked the 9iSQL Reference and it didn't say you cannot use DISTINCT in SELECT ... FOR UPDATE.

Can any body confirm this. Thanks.