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 -> Re: Enforcing hierarchial tree integrity

Re: Enforcing hierarchial tree integrity

From: Peter Griffin <peter_at_guy.com>
Date: Fri, 29 Jul 2005 21:46:29 GMT
Message-ID: <VsxGe.110018$wr.13740@clgrps12>


Sybrand Bakker wrote:
> On Fri, 29 Jul 2005 17:54:41 GMT, Peter Griffin <peter_at_guy.com> wrote:
>
>

>>It's simple enough to do on the client-side which is how our current 
>>implementation does it, but I'd really rather enforce this on the 
>>Oracle-side instead for 100% integrity.
>>
>>Any suggestions on how to go about doing this on the server-side?

>
>
> You did read my response?
> What part of it you didn't understand?

I got it. Just couldn't wrap my brain around that a foreign key constraint can reference back to the same table. Works great, thanks to some help from a very eloquent and charming fellow (not you) but I DO appreciate your time and effort.... I really do. Received on Fri Jul 29 2005 - 16:46:29 CDT

Original text of this message

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