you get a row lock execlusive...
if the value of mycolum match all the table then you will lock all the table in exclusive mode
-----Original Message-----
From: Cox, Nick [mailto:Nick.[Email Address Removed] Thursday, November 27, 2003 11:32
To: LazyDBA.com Discussion
Subject: quick lock question
If I do a
delete mytable where mycolumn='MYVALUE'
what kind of lock do I get on mytable ?
cheers,
\n
Nick Cox
Database Infrastructure
Sherborne House, 119-121 Cannon Street, London. EC4N 5AT.
Tel: + 44 (0) 20 7653 7096 Direct
Tel: + 44 (0) 20 7653 7699 Database Support Hotline
Tel: + 44 (0) 7713 790628 Mobile
Fax: + 44 (0) 207 984 0270
**********************************************************************
This is a commercial communication from Commerzbank AG.
This communication is confidential and is intended only for the person to
whom it is addressed. If you are not that person you are not permitted to
make use of the information and you are requested to notify
<mailto:LONIB.[Email Address Removed] immediately that you have
received it and then destroy the copy in your possession.
Commerzbank AG may monitor outgoing and incoming e-mails. By replying to
this e-mail you consent to such monitoring. This e-mail message and any
attached files have been scanned for the presence of computer viruses.
However, you are advised that you open attachments at your own risk.
This email was sent either by Commerzbank AG, London Branch, or by
Commerzbank Securities, a division of Commerzbank. Commerzbank AG is a
limited liability company incorporated in the Federal Republic of Germany.
Registered Company Number in England BR001025. Our registered address in
the UK is 23 Austin Friars, London, EC2P 2JD. We are regulated by the
Financial Services Authority for the conduct of investment business in the
UK and we appear on the FSA register under number 124920.
**********************************************************************
---------------------------------------------------------------------------------------------------------------
This message contains information that may be confidential or privileged.
If you are not the intended recipient, you may not use, copy or disclose
to anyone any of the information in this message. If you have received
this message and are not the intended recipient, kindly notify the sender
and delete this message from your computer.
Oracle LazyDBA home page