Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to create a 6 byte alphanumeric sequence?
Sorry I meant base 36. You did not specify your character sequence
either ... is it 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ ?
36^6 = 2176782336 so a sequence object would need to be defined to go at least this high.
I'd google around to look for a decimal/hexadecimal converter, and adapt that code to your alphabexadecimal system.
I love how google has become a verb.
Martin
Martin Doherty wrote:
> Can this key sequence tolerate gaps? If so, a solution might be built
> by applying a function to <sequence_name>.nextval to convert a base 10
> number into a base 26 number. If not, then you will need to make the
> sequence transactional e.g. next_available_key is stored in a row of a
> table, and becomes a source of contention (it will serialize your
> transactions).
>
> For performance, I would go with the first approach if possible.
>
> Martin
>
> raoul wrote:
>
>> I am looking for a code snippet or any suggestions on creating a 6
>> byte alphanumeric sequence in PL/SQL or SQL*Plus. Example: 123DE5 I
>> will be using this program to generate and populate a table with these
>> 6 byte alphanumeric sequences to be used by my applications. So the
>> sequence must increment by one.
>>
>> Any help will be greatly appreciated.
>>
>> Thanks,
>> R.
>>
>>
>
Received on Fri Oct 25 2002 - 19:29:38 CDT