Re: SQL - the FOR in a SELECT statment

From: TurkBear <johng_at_mm.com>
Date: Tue, 15 Sep 1998 21:35:16 GMT
Message-ID: <35ffdd4d.12277323@news2.mm.com>

This appears to be a cursor definition used in Pl/SQL - the 'for update of' clause is needed if the value of status is going to be changed.....( something about locks...)

jal_at_esc188.expansion.com wrote:

>Hello,
>
>There is a select statement with a FOR in it which I do not know what it is for.
>Can anyone help. Here is a sample:
>
> select no
> , act
> , status
> , ref1
> , ref2
> into cur_act
> from act
> where no = act_no
> for update of status;
>
>
>Thanks,
>
>Jason

To reply please remove the 'nospam' part of the address Received on Tue Sep 15 1998 - 16:35:16 CDT