Re: locking question

From: Tony BenBrahim <tbenbrahim_at_houston.rr.com>
Date: Fri, 19 Nov 1999 23:10:54 GMT
Message-ID: <2OkZ3.845$y8.102927@typhoon2.austin.rr.com>

select will cause a lock if for update is specified in PL/SQL. ex:

cursor c is

        select EMP,LNAME,FNAME
        from EMPLOYEES
        for update of EMP;

Tony

<kal121_at_yahoo.com> wrote in message news:8147cs$3sc$1_at_nnrp1.deja.com...
> This may seem like a dumb question, but the only types of DML
> statements that put locks on tables are INSERT, UPDATE, and DELETE,
> right? SELECT statements do not places locks on tables, right?
>
> I have looked up this information in several sources, but there is no
> mention of SELECT statements and locking. I don't just want to "assume"
> anything.
>
> thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 19 1999 - 17:10:54 CST