Re: Row locking and serializability

iggy_fernandez_at_my-deja.com wrote:

> The question that remains unanswered is how
> serializability may be manually achieved when
> using Oracle.

This one seems easy -- just lock "the whole" table:

alter session set isolation_level=serializable; select * from passengers for update;
insert into passengers values 'Z';
commit;

Thransaction above is serializable indeed. Received on Tue Jul 06 1999 - 15:49:26 CDT