Re: on update cascade

See Thomas Kyte site, URL:
http://govt.oracle.com/~tkyte/update_cascade/index.html

--
Have a nice day
Michel

<jeanch_at_my-deja.com> a écrit dans le message : 890ov6$q7r$1_at_nnrp1.deja.com...
> hi folks,
>
> I was wondering if on can do 'on update cascade'
> to allow foreign key to be changed by oracle
> when the primary key is altered. For instance
>
> tab1(key) key is primary key for tab1
> tab2(key_FK) is foreign keys
> pointing back to tab1
> If I do
> update tab1 set key = 2 where condition...
> then in tab2 key_fk is updated to reflect that
> change.
>
> Any idea how I can achieve this.
> Cheers
> JC
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Feb 23 2000 - 08:47:10 CST