Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Tutorial D with + restrict
>
>> WITH ( SP RENAME ( SNO AS X ) ) AS R : >> EXTEND ( S { SNO } ) ADD ( COUNT ( R WHERE X = SNO ) AS NP )
Yes that is exactly what i have thought.
> What RESTRICT ? I see WHERE in the scope of EXTEND in there.
Yes EXTEND is a keyword here, you have given me right direction, thank you.
EXTEND A ADD exp AS Z is a relation with:
...
A body consisting of all tuples t such that t is a tuple of A extended with
a value for attribute Z that is computed by *evaluating* exp on *that*
tuple of A.
Thank you. Received on Thu Mar 30 2006 - 06:11:14 CST