Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Referrential integrity
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
![]() |
![]() |