Re: Referential Integrity
When you build the table, you can use the below as part of the create clause for a column.
REFERENCES table [(column, ...)] [MATCH FULL | MATCH PARTIAL] [ON DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT}] [ON UPDATE {RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT}]
I think the option for ON UPDATE/DELETE you are looking for is cascade.
Subject
Views
Written By
Posted
3357
February 26, 2005 07:30AM
Re: Referential Integrity
2184
March 02, 2005 08:13AM
1859
March 03, 2005 09:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.