Re: Nulls in Foregn Key

In article <32914DD7.23A1_at_wiztec.co.il>, rasnier_at_wiztec.co.il says...
> Hi all,
>
> In Oracle Data Base I know we can define Nulls in Foregn key in a
> table.
> Is it desirable or should I put a default value for Foreng key
> column in a table in order to avoid null value ?

Does it make sense for the value of the foreign key to be null? You can make the column not null if it isn't.
If null values are appropriate, would there be a lot of searching for records with null values? Searches for null values don't use indexes. Of course, if you decide to use a default, it must exist in the parent table. Received on Tue Nov 19 1996 - 00:00:00 CST