Re: Enforcing hierarchial tree integrity
- From: Sybrand Bakker <postbus@xxxxxxxxxxxxxxxxx>
- Date: Thu, 28 Jul 2005 22:32:54 +0200
On Thu, 28 Jul 2005 20:20:09 GMT, Peter Griffin <peter@xxxxxxx> 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
.
- References:
- Enforcing hierarchial tree integrity
- From: Peter Griffin
- Enforcing hierarchial tree integrity
- Prev by Date: Enforcing hierarchial tree integrity
- Next by Date: Re: Rman - Curious Question
- Previous by thread: Enforcing hierarchial tree integrity
- Next by thread: Re: Enforcing hierarchial tree integrity
- Index(es):
Relevant Pages
|
