Re: Ora Integrity constraint?

From: <un2000_at_my-deja.com>
Date: Tue, 13 Jul 1999 21:40:26 GMT
Message-ID: <7mgbo8$vfa$1@nnrp1.deja.com>

I donot think there is such a clause. You can remove dependencies by using the ON DELETE CASCADE though. As far as an Update is concerned triggers will work; more so thats the only way out with distributed databases.

In article <7mf5q6$fk1$1_at_nnrp1.deja.com>, jcnv_at_hotmail.com wrote:
>
>
> Hi,
>
> Does Oracle supports ON UPDATE clause in FOREIGN KEY
> definition? Do we have to create a trigger or is there
> any other solution for this?
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 13 1999 - 16:40:26 CDT