Re: Mixed Alphanumeric Unique IDs???

dave_at_simcik.com (DTS) wrote in message news:<d78648f5.0304301403.38201077_at_posting.google.com>...
> 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
Take a look at sys_guid. Might be what you are looking for.

SQL> select sys_guid() from dual;

SYS_GUID()

• Jusung Yang