| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: MV Keys
mAsterdam wrote:
> Marshall Spight wrote:
> > Jon Heggland wrote:
> >
> > The relational operators don't handle lists very well.
> >
> > myList.removeAt(3)
> >
> > vs.
> >
> > BEGIN
> > delete from MyList where Index = 3;
> > update MyList set Index = Index - 1 where Index > 3;
> > COMMIT
>
>
> Aside (the example surely illustrates your point)
> could this removeAt operation possibly be useful
> in a concurrent environment?
>
> You'ld never know which item you are going to scratch -
> somebody else could have just done myList.removeAt(2).
What happened to concurrency contro in your hypothetical system ? Received on Fri Mar 03 2006 - 11:22:28 CST
![]() |
![]() |