Results 1 to 3 of 3

Thread: RI question

  1. #1
    Join Date
    Dec 2001
    Posts
    80

    Unanswered: RI question

    When I add RI constraint, I can have the option "on delete cascade/set null", but I didn't find the option "on update cascade/set null", is it true?

    If true, how can I do cascade/set null on the child record on update of parent record?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Oracle doesn't support ON UPDATE CASCADE/SET NULL. This Tom Kyte article shows how to achieve that.

  3. #3
    Join Date
    Dec 2001
    Posts
    80
    Quote Originally Posted by andrewst
    Oracle doesn't support ON UPDATE CASCADE/SET NULL. This Tom Kyte article shows how to achieve that.
    thx andrewst.

Posting Permissions

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