RE: NULL Foreign Key Value

Guys,

Thanks for all the replies. They were all very helpful but quite embarassing to a person like me who had been an Oracle Forms Developer before going into Database Admin and who had been with this technology since 7.0x.

It took one little reminder from Mr. Ault who had been one of the first to respond that this was basic ERD stuff to realize that my mind had taken on a different level ('fighting fires', new projects not necessarily DBA-related anymore). It was just now that I had the chance to get back to ERD because of a new conversion project that the application vendor itself doesn't want to handle because the version was too old for them. Call it a lapse please or Alzheimers setting in if you want. But the following deluge of examples made the saying 'Common sense is very uncommon' all too apparent. I guess I deserved this.

So as Oracle Support use to say, 'This thread is closed' :)

Thanks for all your help,

George

-----Original Message-----
Sent: Friday, July 27, 2001 10:53 AM
To: ORACLE-L_at_fatcity.com
Cc: GHofilena_at_cnv.org

Because the relation is optional.

Jared  

                    George

                    Hofilena             To:     Multiple recipients of list
ORACLE-L <ORACLE-L_at_fatcity.com>        
                    <GHofilena_at_cnv       cc:

                    .org>                Subject:     NULL Foreign Key Value

                    Sent by:

                    root_at_fatcity.c

                    om

 

 

                    07/26/01 10:56

                    AM

                    Please respond

                    to ORACLE-L

 

 

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).



-- 
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).