Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Posts
    6

    Unanswered: Significance of DELETE_RULE constraint over referential integrity?

    Hi,

    Could you explain the significance of the DELETE_RULE constraint, i.e. the DELETE_RULE value of ALL_CONSTRAINTS table?

    i would like to know how its value affects referential integrity during operations like insert/update on parent and child tables.

    Thanks
    Roy

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Look at this page from Oracle Docs and search for "ON DELETE". There are some examples there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •