Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Mixed Alphanumeric Unique IDs???

Mixed Alphanumeric Unique IDs???

From: DTS <dave_at_simcik.com>
Date: 30 Apr 2003 15:03:47 -0700
Message-ID: <d78648f5.0304301403.38201077@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

Received on Wed Apr 30 2003 - 17:03:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US