Re: Custom Sequence Generator
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Wed, 15 Oct 2014 14:47:46 -0600
Message-ID: <543EDD72.5000300_at_gmail.com>
Given that the documentation states
Date: Wed, 15 Oct 2014 14:47:46 -0600
Message-ID: <543EDD72.5000300_at_gmail.com>
Given that the documentation states
MAXVALUE Specify the maximum value the sequence can generate. This integer value can have 28 or fewer digits for positive values and 27 or fewer digits for negative values. MAXVALUE must be equal to or greater than START WITH and must be greater than MINVALUE.
and you only want to use 12 out of the possible 28 digits, what exactly is your concern?
/Hans
On 15/10/2014 2:28 PM, Ebadi, Abdul wrote:
>
> Hi,
>
> We have a need to generate a 10 or 12 digit unique key. Anyone have a
> quick function for this? For example: 435A24C1.
>
> We don’t want to use Oracle’s sequences as we are afraid we will run
> out of unique ones. We need billions of these keys.
>
> Thanks,
>
> Abdul
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 15 2014 - 22:47:46 CEST