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: Enforcing Hierarchical Relationships

Re: Enforcing Hierarchical Relationships

From: JoeZ53 <joez53_at_aol.com>
Date: 17 May 1999 19:07:55 GMT
Message-ID: <19990517150755.21440.00002659@ng-fi1.aol.com> 





Remove the foreign key constraint altogether. 



Now you will be able to use the tree query without the mutating problem.  Also
add logic to validate the foreign key relationship in the pre-insert trigger.
Received on Mon May 17 1999 - 14:07:55 CDT












Original text of this message













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