on update cascade

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 - 07:56:57 CST