Re: foreign keys - cascade

On update cascade doesn't exist and needs to be implemented by triggers. On delete set default also doesn't exist: the only option you have is nullify (starting in 8i)
The website of Thomas Kyte has a package which will generate the 'on update cascade' triggers for you.

Hth,

Sybrand Bakker, Oracle DBA

<ronalddebruin_at_my-deja.com> wrote in message news:9611md$u3$1_at_nnrp1.deja.com...
> Hi there,
>
> I'd like to specify a foreign key with an 'on update cascade'
> constraint. Does anyone know how to do this. Also does anyone know how
> to specify a foreign key with an 'on delete set default' constraint.
>
> Thank you very much!
>
> Ronald
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Feb 09 2001 - 11:18:42 CST