Lock Table

Is there a way to lock table for select.

I.E. Something a bit stronger than

LOCK TABLE MY_TABLE IN EXCLUSIVE MODE; Tried this and on a separate sqlplus session I could do

select (1) from my_table;

As per documentation I might add. However I would like it not to be possible to do this.

Thanks,
Iain Received on Thu Sep 08 2005 - 02:33:40 CDT