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

Home -> Community -> Usenet -> c.d.o.server -> on delete set null

on delete set null

From: Doug Cowles <dcowles_at_us.ibm.com>
Date: Mon, 10 Jan 2000 16:14:24 -0500
Message-ID: <387A4BB0.5C4F1ADE@us.ibm.com> 





I am happy that on delete set null works in Oracle 8i.  However, I see
no confirmation of it's implementation in user_constraints.  The delete
rule still specifies NO ACTION ENBLED, even though it is clearly
implemented with add contraint xyz foreing key (id)
refereneces othertable(id) on delete set null.
What am I missing?


- Dc.

Received on Mon Jan 10 2000 - 15:14:24 CST












Original text of this message













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