Re: Check for no more than two entries of each value in a column?
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 17 Apr 2009 21:15:07 +0200
Message-ID: <49E8D53B.7050801_at_gmail.com>
Shakespeare schrieb:
> ddf schreef:
>
>
>
>
> This could only happen with the same nominator voting in different
> sessions at the same time....
>
> Shakespeare
Date: Fri, 17 Apr 2009 21:15:07 +0200
Message-ID: <49E8D53B.7050801_at_gmail.com>
Shakespeare schrieb:
> ddf schreef:
>> On Apr 17, 12:38 pm, livefreeordie <jpittm..._at_gmail.com> wrote: >>> Hi,
>
>> knip knip
>
>
>> With the commit inside the procedure you *should* be able to keep to >> the two nominations maximum per nominator (of course depending upon >> how active this nomination process can be with multiple users you may >> have a few slip through the cracks). >> >> >> David Fitzjarrell
>
> This could only happen with the same nominator voting in different
> sessions at the same time....
>
> Shakespeare
It could be extended however by user defined locks (dbms_lock) to serialize the access to the table in question.
Best regards
Maxim Received on Fri Apr 17 2009 - 14:15:07 CDT