Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to add a constraint with ON UPDATE CASCADE in 12c

963732Aug 22 2014 — edited Aug 25 2014

Hi,

I am porting a MySQL database over to Oracle where I need to add the following constraint :

<blockquote>ALTER TABLE customer ADD CONSTRAINT customer_address_id_fkey FOREIGN KEY (address_id) REFERENCES address(address_id) ON UPDATE CASCADE</blockquote>

How do we implement in Oracle.

Many thanks !!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2014

Added on Aug 22 2014

#general-database-discussions

7 comments

3,045 views