Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Locking Multiple records
On 11 Nov 2003 02:29:17 -0800, runa_b_at_indiatimes.com (Runa) wrote:
>Is there anyway in which I can lock multiple records together, but
>release the lock one at a time i.e commit changes to one record at a
>time?
>
>Thanks.
>Runa
No there isn't, as this would violate the basic concept of a transaction.
-- Sybrand Bakker, Senior Oracle DBAReceived on Tue Nov 11 2003 - 13:05:36 CST