Skip to Main Content

SQL & PL/SQL

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!

Add ON DELETE CASCADE

BilalKhanFeb 8 2011 — edited Feb 8 2011
hi every body.

i want to add the constraint "ON DELETE CASCADE" on foreign key value in child table like.

ALTER table employee
Add CONSTRAINT cscade_dept_no ON DELETE CASCADE (Deptno)

but it display error message, so please help me in this regards.


Thanks

Edited by: BilalKhan on Feb 7, 2011 11:53 PM
This post has been answered by Dbb on Feb 8 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2011
Added on Feb 8 2011
5 comments
515 views