| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: MV Keys
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). Received on Fri Mar 03 2006 - 11:11:27 CST
![]() |
![]() |