Re: NULL Foreign Key Value

Hi George

This is not something that Oracle have defined, this behaviour is part of the SQL ANSI standard.

George Hofilena wrote:

> Can somebody explain why Oracle would allow a foreign key to be null and
> still enforce the referential integrity constraint.
>
> Thanks,
>
> George Hofilena
> DBA
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: George Hofilena
> INET: GHofilena_at_cnv.org
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Best regards

Peter Gram

Miracle A/S
http://MiracleAS.dk
Tel: +45 2527 7107