For Update clause

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.