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?
http://www.marston-home.demon.co.uk/Tony/tip32.html
has a conversion algorithm for all bases up to 36, written in a 3GL
language called Uniface.
Courtesy of Google. Approximate search time = 30 seconds.
Martin Doherty wrote:
> 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 - 20:11:33 CDT
![]() |
![]() |