OraFAQ Forum: SQL & PL/SQL » Please clarify the LOCK doubts

Home » SQL & PL/SQL » SQL & PL/SQL » Please clarify the LOCK doubts (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Please clarify the LOCK doubts [message #626723]

Sat, 01 November 2014 02:07

ramya_162
Messages: 107
Registered: August 2013
Location: Banglore

Senior Member

Hi Experts,

Please clarify the LOCK doubts

Q1)
USER firing the below select statement the table or rows will be locked?

USER:

SELECT * FROM emp;

Q2)
USER firing the below DML statement the table or rows will be locked?

USER:

UPDATE emp set sal=sal+100 WHERE deptno=10;

Q2)
USER firing the below DML statement the table or rows will be locked?

USER:

UPDATE emp set sal=sal+100

Please help me.

Thanks.

Report message to a moderator

Re: Please clarify the LOCK doubts [message #626726 is a reply to message #626723]

Sat, 01 November 2014 02:29

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You did never feed back nor thank people that have helped you, so why should continue to do it?

Anyway, all these questions are answered in Database Concepts.

Report message to a moderator

Re: Please clarify the LOCK doubts [message #626734 is a reply to message #626723]

Sat, 01 November 2014 07:08

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

http://docs.oracle.com/cd/E11882_01/server.112/e40540/consist.htm#CNCPT1339

[Updated on: Sat, 01 November 2014 07:09]

Report message to a moderator

Previous Topic:	FOR UPDATE OF not working
Next Topic:	Hierarchy problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 19:42:55 CDT 2024