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