Re: LOCK TABLE
From: Theodore Do <tdo_at_mailsrv1.trw.com>
Date: 1995/09/15
Message-ID: <43d1je$iom_at_tnn-wan.trw.com>#1/1
Date: 1995/09/15
Message-ID: <43d1je$iom_at_tnn-wan.trw.com>#1/1
vinodb_at_sdt.com (Vinod Bidarkoppa) wrote:
>How can I explicitly Lock a table in exclusive mode for updates and then
>do a release on the lock?
>I understand that the dbms_lock package is only for obtaining locks on
>peripherals.
>
To lock a table X in exclusive mode use:
lock table X in exclusive mode;
rem : do your stuff.
commit;
-Ted.
-- ============================================= = Theodore Do = = Senior Technical Specialist, UNIX/ORACLE = = TRW Information Technology Services = = tdo_at_mailsrv1.trw.com = =============================================Received on Fri Sep 15 1995 - 00:00:00 CEST