пятница, 22 апреля 2016 г.

synchronized accessing table in Oracle

We have 2 session and 1 table to operate with
If we want to edit, we check lock and throw an error if the table is already busy: While load we make lock befor And unlock after For working with dbms_lock you need get right: To view locks User defined locking with DBMS_LOCK
DBMS_LOCK.REQUEST (PLS5H3)