Can't understand what you mean by ?
surrogate IOW autogenerated ids.
Aashish
>Take ? I said surrogate IOW autogenerated ids.
>Cetin
>
>>Well, primary key defined fields in Oracle dosent take empty or null values.
>>
>>Aashish
>>
>>>I believe in Oracle too you can generate surrogate primary keys.
>>>Cetin
>>>>I am mainly an Oracle guy. So it was tough for me to digest.
>>>>
>>>>Aashish
>>>>
>>>>>>Hi,
>>>>>>
>>>>>>Primary key accepts empty values. Should Primark Key behave like this ?
>>>>>>Am I wrong somewhere ?
>>>>>
>>>>>If a primary key is accepting an empty value it's normal. It ensures value would be unique but doesn't guarantee it wouldn't be empty. ie: For an integer PK 0 is a perfectly legal value.
>>>>>But if a primary key is accepting empty value
s then you've a problem. Keys might not be updating at all.
>>>>>Not empty is something you should control as well as not null.
>>>>>Cetin