Oracle-L: Re: ON DELETE SET NULL ??

From: Thomas Day <tday6_at_csc.com>
Date: Mon, 19 May 2003 11:42:20 -0800
Message-ID: <F001.0059CDD9.20030519114220@fatcity.com>

It;'s telling Oracle what the child behavior is when the parent is deleted. In this case the foreign key is set to null when it's parent record is deleted. No referential integrity.

                                                                                                                                       
                      Janet Linsy                                                                                                      
                      <janetlinsy              To:      Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                      @yahoo.com>              cc:                                                                                     
                      Sent by: root            Subject: ON DELETE SET NULL ??                                                          
                                                                                                                                       
                                                                                                                                       
                      05/19/2003 02:56                                                                                                 
                      PM                                                                                                               
                      Please respond                                                                                                   
                      to ORACLE-L

Hi,

I used Erwin 3.5.2 to generate script. The DDL has the following, what exactly is ON DELETE SET NULL part?

ALTER TABLE ED_RECORDINGS_PAYMENTS

       ADD FOREIGN KEY (RECORDING_ID)
                             REFERENCES ED_RECORDINGS
                             ON DELETE SET NULL;

Thanks in advance.

Janet

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Janet Linsy
  INET: janetlinsy_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: Thomas Day
  INET: tday6_at_csc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Mon May 19 2003 - 14:42:20 CDT