| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: is pivoted phones view updateable?
NENASHI, Tegiri wrote:
> "Aloha Kakuikanu" <aloha.kakuikanu_at_yahoo.com> wrote in
> v1 is the view that is a subset of r1: v1 = {1,2,.., 10}. I removed the
> attribute name for simplicity.
You made a typo, as clearly you didn't mean v1 = {1,2,.., 10}, or is a constant in other words. What you meant to say:
v1 = r1 join {1,2,.., 10}
> >
> > I agree that this example is not invertible. But switch the roles of
> > 10 and 100 and it becomes updateable!
>
> Please explain.
r1 union {1,2,.., 10} = {1,2,.., 10}
v1 = r1 join {1,2,.., 100}
v1 is invertible. Received on Fri Nov 17 2006 - 11:48:44 CST
![]() |
![]() |