Exists foreign key "on update cascade"
From: Norbert Winkler <Norbert.Winkler1_at_gmx.de>
Date: Mon, 25 Feb 2008 15:50:26 +0100
Message-ID: <1pc452g2zhupc$.1h2ztc6e3tuxh$.dlg@40tude.net>
Date: Mon, 25 Feb 2008 15:50:26 +0100
Message-ID: <1pc452g2zhupc$.1h2ztc6e3tuxh$.dlg@40tude.net>
Hi,
google says no, and my SQL-reference I have doesn't mention it. Thats why the question:
In other DBs it is possible to define a foreign key with
"ON UPDATE CASCADE"
what means: I change a (primary-)key-value in the master-table and all
foreign-key-values in detail-tables are changed accordingly.
Is there any oracle-version that does it.
I only found:
ON DELETE/UPDATE NO ACTION, ON DELETE CASCADE und ON DELETE SET NULL
-- NorbertReceived on Mon Feb 25 2008 - 08:50:26 CST