Re: Row level locking: how to do it?
From: Leng Kaing <leng_at_cougar.vut.edu.au>
Date: 1996/08/03
Message-ID: <DvJusp.88x_at_matilda.vut.edu.au>#1/1
Date: 1996/08/03
Message-ID: <DvJusp.88x_at_matilda.vut.edu.au>#1/1
Lim Tik Meng (mte_at_moe.ac.sg) wrote:
: We are trying to solve a problem involving concurrency processing in
: embedded SQL in forms 4.5 trigger. We will greatly appreciate if anyone
: could guide us on how to do row level blocking. The Lock Table command
: doesnot work for row level locking.
: regards,
: Peter
By default oracle does row level locking. So you've accomplished it
without even knowing it! There's no "lock row" command. Whenever you
do an update or delete, you are locking a row.
Leng.
--
Leng Kaing
DBA - Directory Technology P/L
Email: lkaing_at_ventnds1.telecom.com.au
Ph: +61-3-9892-9081 Fax: +61-3-9892-9344
WWW: http://www.vut.edu.au/voug
Received on Sat Aug 03 1996 - 00:00:00 CEST