Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Referrential integrity

Re: Referrential integrity

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/11/05
Message-ID: <63p6m4$b9$1@news00.btx.dtag.de>#1/1

Hi,

excuse me. This was a hint for Q3. It works unde 7.3.3.4.

Q2:

Can be done in a before-delete trigger.

Update Childtable set fk-field=null where fk-field=:old.pk;

fk-field in childtable must be defined to include NULL-values.

-- 
Regards

M.Gresz    :-)
Received on Wed Nov 05 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US