Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: For Update clause

Re: For Update clause

From: Han Zijlstra <hzijlstr_at_hiscom.nl>
Date: Mon, 21 Aug 2000 13:12:28 +0200
Message-ID: <8nr2qt$jpj$1@porthos.nl.uu.net>

'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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US