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

    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
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool



    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
  •