Re: P a r t i a l k e y s

miguel wrote:
>
> Does anyone plese tell me if we can use partial keys on Oracle 7.1.6? For
> example if we can use the first two caracters from a VARCHAR column (NOT
> NULL) ?
If you mean can you declare part of a column to be a primary or foriegn key in the create table statament, the answer is NO.

It would seem reasonable that a data item of sufficient importance to be a key deserves its own column :-)

Chrysalis. Received on Mon Apr 28 1997 - 00:00:00 CDT