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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 28 Jul 2005 22:32:54 +0200
Message-ID: <m6gie1965r0rdd01g1cv65at1i2u1puhss@4ax.com> 





On Thu, 28 Jul 2005 20:20:09 GMT, Peter Griffin <peter_at_guy.com> wrote:



>Basically, when a node is deleted then all of it's children (if any) 

>should get deleted too. I suspect this needs to be done using a delete 

>trigger.




Just create the constraint with on delete cascade.
That is all there is to it.



--
Sybrand Bakker, Senior Oracle DBA


Received on Thu Jul 28 2005 - 15:32:54 CDT












Original text of this message













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