Re: Mixed Alphanumeric Unique IDs???

DTS wrote:
>
> Hi group,
> I'm wondering what the best way is to construct unique ID's for
> primary keys and such. I would like to create unique keys that use a
> combination of letters and numbers. Oracle sequences only generate
> numbers - should I consider some form of hashing algorithm, such as
> MD5? In general, what are the best practices for primary key usage in
> Oracle???
>
> THANKS!
> DTS
A quick and easy way is to convert the number to hex, then you will "pseudo-alphanumeric"

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"