Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006

    Unanswered: ON UPDATE CASCADE in 10G

    I have a question about Oracle 10G and the support of the idea of cascading on Update when having a database design using referential integrity.

    Oracle is a better product than SQL Server 2000 but SQL Server supports this type of cascading action whereas Oracle 8i and 9i do not. Does Oracle 10G support action?

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    The ON DELETE CASCADE constraint option is provided for support of referential integrity, please check the manual for details.

    PS: The SQL Server 2000 ON INSERT/UPDATE CASCADE option is automatically supported in oracle (not in syntax but) by the existence/non-existence of the ON DELETE CASCADE constraint option.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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