Re: Updates, commits and row locks

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 07 Jun 1999 18:47:46 GMT
Message-ID: <375c13ba.24792609@newshost.us.oracle.com>

A copy of this was sent to amyleone_at_my-deja.com (if that email address didn't require changing) On Mon, 07 Jun 1999 17:25:31 GMT, you wrote:

>Hello! If I update a row, can I update it again
>before I commit, or is it locked?
>

you (your session) can update it as many times as you like within that transaction. Other sessions cannot.

>Amy Leone
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jun 07 1999 - 13:47:46 CDT