Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: For Update clause
'count(*)' is a group function; it is not allowed in a for update clause; an
d it doesn't make sense: which rowes you thought to update?
"SmartJaggu" <sujaggu_at_yahoo.com> wrote in message
news:8nqc17$8lh$1_at_nnrp1.deja.com...
> Hello all !
>
> Could anybody please tell me with what all clauses part of an SQL slecet
> stmt the "For Update" clause does not go ?
>
> I know some, like :
> select count(*) from sysparam for update ;
> gives error ORA-01786. But I need a comprehensive list of the things
> which give error :
> 01786, 00000, "FOR UPDATE of this query expression is not allowed"
>
> Thanks in advance,
> Sandeep
>
> --
> Such is life and such is growing
> And thru' mistakes, we end up in knowing !!!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Aug 21 2000 - 06:12:28 CDT