Re: Row and Table Locking

From what your requirements are, there should be no need to specifically lock the rows, Oracle will do row level locking. There can be specific instances where you would want to lock the rows you are working with, but, it sounds like that it's not the case here.

HTH
Pete's

kafis_at_super.net.pk (Nadeem Kafi) wrote in message news:<f1698545.0108232016.51f79c0c_at_posting.google.com>...
> Hello All,
>
> I want to confirm that there is no need to explicitely lock
> tables and rows during updates and deletes after the row
> level lock provided by Oracle after Version 6. i.e.
>
> Before each update/delete to a row in a table there is no need to
> lock the row. Oracle will do it automatically.
>
> One of my inherited application contains PL/SQL code which lock
> tables in share update mode (or using select...for update nowait)
> before every update and delete. Now using Oracle 8.1.6, I feel
> there is no need. BTW, there are no explicity application specific
> locking requirements.
>
> Best Regards,
> Nadeem Kafi.
Received on Fri Aug 24 2001 - 08:07:21 CDT