Re: optimum datatype for primary key column O9i

Hi

You can use varchar2...but i suggest you dont code any intelligence in these keys...use dumb keys like this

My_dumb_key     My_key
1               A12
2               A2

now make my_dumb_key as your primary which is a number populated by a sequence or something..

I think this is the best.You can make My_key unique..

Read books on data modelling they will have detailed explanation

regards
Hrishy Received on Mon Oct 27 2003 - 16:30:12 CET